Minfy Technologies - Senior Database Administrator - SQL Server (3-5 yrs)

Job Description :

- About the job SQL Server installation / configuration on EC2 and cloud.

- In-depth knowledge on SQL server schema, backups, recovery, HA along with user /security management.

- Should posses good understanding of working with joins, views, triggers and stored procedures.

- Designs, installs, upgrade, monitors, maintains, and conducts performance tuning procedures in a production MS SQL Server database environment while ensuring high levels of data availability.

- Ensure high levels of performance, availability, sustainability and security.

- Develops, implements, and oversees MS SQL Server database policies and procedures to ensure the integrity and availability of databases and their accompanying software.

- Create, maintain, and execute scheduled jobs, data extracts, data refreshes, data loads and data replication.

- Detect and troubleshoot DB Server CPU, Memory, I/O, SQL Profiler and other resource contention Solid knowledge on performance tuning from MSSQL databases.

- Design, implement, and test backup and recovery strategies that ensure 100% data availability.

- Develop data scripts, troubleshoot code and assist developers with performance tuning.

- Manage AWS Managed MSSQL RDS instances , solid understanding to support the AWS cloud database.

- Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking.

- Worked as a team member to provide 247 on-call production database support.

- Knowledge on PostgreSQL will be an added advantage.

Experience on ETL, OLAP, SSRS, SSIS will be added advantage

- -