Software Development Specialist

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

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