Senior SQL Server DBA opening with Icertis Pune

                                                

Position name:

Senior SQL DBA

Key Areas of Responsibility:

·         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.

·         Develop strategies and implement solutions for managing back-ups, restoration and replication.

·         Create and manage constraints and indexes.

·         Support software developers with database operations including the development of complex SQL and the creation of stored procedures.

·         Proactive housekeeping/archiving and shrinking of databases.

·         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 all the stakeholders (internal teams and clients).

Requirements / Qualifications:

·         Bachelors or Master’s degree in computer science or equivalent education and experience.

·         10-15 years’ experience in administering Microsoft SQL server databases.

·         Strong problem solving skills and high motivation levels to tackle complex production problems.

·         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.

·         Experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies would be an advantage.

·         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.

Experience: 

10+ years

Job Location:

Baner Road Pune, India