Verified Job
IT / Software / Data Analyst
Sr DBA
IT / Software / Data Analyst
#429478
Remote / WFH
Job Description
Job Description For MS SQL DBA Responsibilities
Install and configure new Microsoft SQL Server instances, including Always On availability groups and failover clustering.
Highly skilled at database design, installations, conversions Responsible for database backup and recovery procedures, access security and database integrity, physical data storage design and data storage management
Must aware of SSL & TLS configuration on standalone as well as clustered environments
Engage in ongoing process improvement
Experienced in Database Performance and Maintenance to perform the following: o Database management including backups, recovery and maintenance o Database management for export, import and mass data loads o Analyzes and generation of all tables and index statistics o Monitoring and resolving data lock issues o Check all statistics related to memory, locks, I/O, database response time, wait events, top sessions and background processes o On Line Transaction Processing (OLTP) to capture, validate and store large amounts of transactions o Create indexes to achieve critical dataset response time for time sensitive reports.
Install SQL Server service packs and updates.
Configure and manage SQL Security settings
Make system design recommendations according to Microsoft SQL Server best practices.
Manage database backup & recovery & DR planning in collaboration with IT manager and System Engineer.
Create, modify, and optimize SQL Server Agent jobs and maintenance plans.
Proactively monitor SQL Server maintenance tasks, troubleshoot failed jobs and resolve issues in a timely manner.
Troubleshoot application slowness and performance issues.
Responsible for ETL of large data into SQL Server Author and modify SQL Server Reporting Services reports.
Perform SQL Server integration with enterprise applications. Qualifications & Experience
Must be certified MCDBA (Exposure on PostgreSQL will be added advantage)
SQL Server Management Studio
DB Troubleshooting, performance and tuning
Experience in Logical and Physical Database modelling
4+ years working as a Microsoft SQL Server Database Administrator (DBA).
2+ years working w/ large databases (1 TB+)
2+ years working in a clustered Windows environment
2+ years w/ SQL Server Integration Services (SSIS)
2+ years w/ SQL Server Reporting Services (SSRS)
Install and configure new Microsoft SQL Server instances, including Always On availability groups and failover clustering.
Highly skilled at database design, installations, conversions Responsible for database backup and recovery procedures, access security and database integrity, physical data storage design and data storage management
Must aware of SSL & TLS configuration on standalone as well as clustered environments
Engage in ongoing process improvement
Experienced in Database Performance and Maintenance to perform the following: o Database management including backups, recovery and maintenance o Database management for export, import and mass data loads o Analyzes and generation of all tables and index statistics o Monitoring and resolving data lock issues o Check all statistics related to memory, locks, I/O, database response time, wait events, top sessions and background processes o On Line Transaction Processing (OLTP) to capture, validate and store large amounts of transactions o Create indexes to achieve critical dataset response time for time sensitive reports.
Install SQL Server service packs and updates.
Configure and manage SQL Security settings
Make system design recommendations according to Microsoft SQL Server best practices.
Manage database backup & recovery & DR planning in collaboration with IT manager and System Engineer.
Create, modify, and optimize SQL Server Agent jobs and maintenance plans.
Proactively monitor SQL Server maintenance tasks, troubleshoot failed jobs and resolve issues in a timely manner.
Troubleshoot application slowness and performance issues.
Responsible for ETL of large data into SQL Server Author and modify SQL Server Reporting Services reports.
Perform SQL Server integration with enterprise applications. Qualifications & Experience
Must be certified MCDBA (Exposure on PostgreSQL will be added advantage)
SQL Server Management Studio
DB Troubleshooting, performance and tuning
Experience in Logical and Physical Database modelling
4+ years working as a Microsoft SQL Server Database Administrator (DBA).
2+ years working w/ large databases (1 TB+)
2+ years working in a clustered Windows environment
2+ years w/ SQL Server Integration Services (SSIS)
2+ years w/ SQL Server Reporting Services (SSRS)
