Job skills & Qualifications

• Must have a college degree or equivalent experience.
• 9-15 years’ experience in administering Microsoft SQL server databases (2012 2019).

Responsibilities

• Develop strategies and implement solutions for managing back-ups, restoration and replication.
• Create and manage multiple databases and assist in capacity planning.
• Monitor & maintain database systems and troubleshoot problems that may arise.
• Maintain data integrity and security (manage roles and permissions of database users).
• Use tools like SQL Profiler for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them.
• Create and manage constraints and indexes.
• Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures.
• Manage production, QA and development database environments.
• Create detailed documentation including diagrams of database infrastructure.
• Learn relevant business processes and understand the data flow, criticality and dependencies.
• Effectively coordinate and communicate with application development teams, DevOps teams and management teams
• Set up and maintain database infrastructure for the company’s BI needs.
• Strong understanding of DataOps principles
• Identifies potential security issues and recommends strategy to ensure database security

Technical Skills

• Experienced in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Experienced in ETL (Extract-Transform-Load) development / data integration.
• Sound knowledge of RDBMS concepts, database architecture and SQL/T-SQL.
• Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance.
• Knowledge of other databases like Elastic Search, Snowflake, Redis, Mongo DB, MySQL, Firebase Realtime, and any No SQL databases.
• Ability to develop procedure documents and maintain detailed database related documents.
• Innovative approach to work, constantly looking for upgrading the system to more efficient and effective new technologies.
• Knowledge of SVN, GIT and code management repositories.
• Excellent trouble shooting, problem resolution an SQL tuning skill.