Day to Day job Duties: (what this person will do on a daily/weekly basis) 

 

Perform SQL Server database installation, instance creation, patching, migrations, and upgrades. Perform and oversee day-to-day database activities related to MS  SQL server error logs, backups, integrity checks, optimizations, refreshing re indexing, performance tuning and troubleshooting.  Develop database scripts for database operational tasks. On-call production support during non-business hrs on a rotational basis within the DBA team.  Develop, establish and maintain overall database standards, processes related documentation and workflows necessary for production using DTS packages, stored procedures, batch jobs and system reports.  Installing, configuring, administering of MSSQL server and securing production servers. Develop best practices for SQL Server AlwaysOn Availability Groups and performing AlwaysOn configuration and supports tasks.

 

Basic Qualifications: (what are the skills required to this job with minimum years of experience on each)

Minimum 8+ years of experience which includes MSSQL in Database Administration & Development, System Analysis, Design, Security and Support of MS SQL Server diff, Testing, Development, Replication & Cluster Server Environments.  Good experience with SQL Server Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), and Power BI tools. Experience in Migrating Database to AWS and Azure Cloud – 2-4 Years experience. Experience in configuring backup strategy and in case of database failure, to recovery the database point in time. Redgate DB monitoring tool implementation, administration experience – 2 years experience.