Lead Consultant – SQL Server Database Admin

Responsibilities

• SQL Server Reporting Services
• SQL Server Integration Services.
• SQL Server Always On
• SQL Server Clustering
• Who is self-driven
• Should be able handle projects and ops independently
• Should be able to speak to app team and work on requirements as needed.
• Installations, configurations, upgrades, patching, performance tuning, reorganization, backup and recovery of SQL Server databases.
• Installing, configuring and security settings for Oracle Database
• Should have worked in High Availability Features like Clustering, Always On, Log Shipping, DB Mirroring and Replication.
• Upgrading/Consolidating/Migrating of Database.
• Cross-Functional Migration from One Technology to Another or On-Prem to Cloud.
• Responsible for ensuring availability and performance of the databases that support the system.
• Performing daily maintenance task for critical databases.
• Establish and maintain sound backup and recovery policies and procedures.
• Setup and maintain documentation and standards.
• Create, maintain and administer monitoring and ongoing maintenance & administration of System Center Operations Manager
• ITIL Skill set requirement (Problem Management/Incident Management/Chain Management etc.)
• Documenting major changes to Database Activities
• Identify, research, and resolve technical problems like Database tuning and performance monitoring, Physical Server Level, Database level (Database settings and options) and query tuning.
• Proactively monitor the database systems to ensure secure services with minimum downtime.
• Automation of regular and repetitive tasks.
• Driving permanent fixes and issue resolution.

• Handling the task of managing database structure, storage allocation, database access, roles, users and privileges.
• Should be involved in troubleshooting, resolving data integrity and monitoring performance issues.
• Should have proven communication skills and experience in handling bridge call. Available for after-hours critical escalations and provide 7×24 supports when required.

Minimum Qualifications

• Strong Knowledge on handling On-Prem Databases and on Cloud (AWS/Azure).
• Relevant years of SQL Server Database Admin and business/industry work experience
• Knowledge of Idera/SCOM and other monitoring tools.

Bachelor's Degree required. Preferably in Computer Science, Information Systems, or related field

Preferred Qualifications

/ Skills

Very good written and presentation / verbal communication skills with experience of customer interfacing role. In-depth requirement understanding skills with good analytical and problem solving ability, interpersonal efficiency, and positive attitude

• Scripting and DevOps Tool Knowledge.
• Experience on cloud agnostic tools like Jenkins, Maven, Terraform etc
• Experience on automation languages like python, shell scripts, pearl/ruby
• Should be effective in communication skills and client communication
• Should proactively look into all support servers with 24 x 7 support whenever the issue arises.
• Solid process skills with an understanding of change control processes and managing critical production environments.
• Strong inter-personal, analytical thinking, presentation and communication skills essential.