Lead SQL Server DBA/Developer

Back To List

Number of Vacancy : 1

Applicant must have: 10+ Years Experience

Mandatory skills

  • High Availability and Disaster Recovery Solution, Installation, Configuration, Administration, Performance tuning, Backup & Recovery, Transact SQL (T-SQL) Coding, XML Queries, PL/SQL, Compliances and Security, Monitoring and Health Check, PowerShell Scripting, Product Development Life Cycle.

Job Description

  • This position is responsible to architecting, managing and administration MS SQL Server Instances and Databases, including development support of daily operations and helps to develop strategies to improve availability and utilization of SQL Server Environment of multination clients having database sizes in multi terabytes on on-prem and cloud.
  • Candidate must have played varying role of SQL Server Architecture, DBA and Developer and managing team of 10+ team members.

Experience Range

  • 10+ years as MS SQL Server Database Administrator cum Developer. Played roles of SQL Server Architecture, DBA and Developer and on-prim and cloud environment.

Education Qualification

  • MTech, BTech, BE, MCA, BE, MSc IT, MCDBA certification preferably.

Essential Skill

  • Must worked on large environment and infrastructure having multiple SQL Server Instances
  • Apart from SQL server core knowledge, Candidate must have knowledge of PostgreSQL, DB2, Informix Database OR willing to learn and manage such heterogeneous databases.
  • Candidate must have played role of SQL Server Architecture, DBA and Developer in his professional career. Truly worked and engaged with technical work and team management capability.
  • Well experienced Lead SQL Server DBA having complete knowledge on all area of High Availability Options (AlwaysOn, AlwayON Clustering, Replication, Mirroring, Log Shipping), Installation, administration, configuration, monitoring, migration, advance performance tuning, backup/restore and recovery option, user and security administration of SQL Server Database Instance and worked on various releases 2017/2016/2014/2012/2008
  • Experience in Implementing backup / recovery strategy, configuring maintenance plans for backups, or using enterprise backup management tools and have expert in all recovery scenarios in case of physical and logical corruption.
  • Proficiency in implementing and utilizing supported features with SQL Server like in-Memory, Change Data Capture, DReplay, Query Store, Full Text Indexing, Partitioning, Encryption etc.
  • For performance tuning, candidate must have expertise in various tools like DTA, DEA, QTA, Extended Events, SQL Profiler, tracing SQLs, Performance DMVs, System Procedures, DBCC Commands and strong knowledge of query optimization and query analysis, reviewing Execution Plans and able to find out performance root cause and advise on recommendations.
  • For performance tuning, candidate must have expertise in various tools like DTA, DEA, QTA, Extended Events, SQL Profiler, tracing SQLs, Performance DMVs, System Procedures, DBCC Commands and strong knowledge of query optimization and query analysis, reviewing Execution Plans and able to find out performance root cause and advise on recommendations.
  • Experienced in database migration and upgrade to later version.
  • Candidate must have knowledge of SQL Server Development areas includes, T-SQL, Stored Procedures, Functions and Triggers and other objects with best practices and adopted standards.
  • Expertise in developing PowerShell scripts, have visibility and passionate about automating tasks with automation tools.
  • Managing and administration of Development/ QA/ Staging/ Production environment process like change management, build process for new development and product release.
  • Working experience with heterogeneous databases & multiple databases. address and resolve Technical Issues related to Databases and provide 24*7 supports with international client. Experienced in handling large databases and aware about pros- and cos- with real-time experience
  • Able to develop SSIS Packages, having knowledge of Reporting and Analysis Services.
  • Added advantage if candidate have Public Cloud knowledge like AWS or MS Azure.

Additional skill sets and expectations

  • Eager to learn other database technologies like PostgreSQL, DB2, Informix, NoSQL databases.
  • Passionate about automating tasks using powershell scripts.
  • Able to work with Consultants and Developers and able to escalate of database issues with Microsoft Support and Development team/Consultant.
  • Good and quality interpretation, written, communication and documentation skill.

Job Condition

  • Able to support 24/7 data center operations in rotational shifts.
  • Ready to work during planed weekend support.
  • Ready to work out-of-hours maintenance and on call support.

Technical Experience/Skills Preferred

  • High Availability and Disaster Recovery Solution, Installation, Configuration, Administration, Performance tuning, Backup & Recovery, Transact SQL (T-SQL) Coding, XML Queries, PL/SQL, Compliances and Security, Monitoring and Health Check, PowerShell Scripting, Product Development Life Cycle.
We want to hear from you. Apply Now!