MSSQL server operations as DB administrator
Job Summary
Install and configure new Microsoft SQL Server instances including AlwaysOn availability groups and failover clustering. Preferably on Microsoft SQL Server.
Highly skilled at database design and T-SQL development.
Responsible for database backup and recovery procedures security and database integrity physical data storage design and data storage management.
Configure and manage SQL Security settings.
Make system design recommendations according to Microsoft SQL Server best practices.
Manage database backup recovery & DR planning.
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.
Analyzes SQL query plans and refines complex queries for performance tuning.
Responsible for database migrations and server upgrades.
SQL Server Integration Services (SSIS) and Data Integration: Develop maintain and optimize SSIS packages for ETL (Extract Transform Load) processes of large data into and out of Microsoft SQL Server.
Optimizes data for visualization and Business Intelligence data analysis.
Perform SQL Server integration with enterprise applications.
Experience Required:
Experienced in Database Design and Development to perform the following:
Database design utilizing various objects development such as Packages Procedures Functions Triggers for business logic implementation
T-SQL procedures development compilation and debugging stored Procedures
DB Troubleshooting performance and tuning
Experience in Logical and Physical Database modelling
Experienced in Database Performance Maintenance and Development to perform the following:
Database management including backups recovery and maintenance
Database management for export import and mass data loads
Analyzes and generation of all tables and index statistics
Monitoring and resolving data lock issues
Check all statistics related to memory locks I/O database response time wait events top sessions and background processes
Create indexes to achieve critical dataset response time for time sensitive reports.
Solid understanding of database security concepts and best practices for Microsoft SQL Server databases.
Experience with source control tools (SVN/Git).
Familiarity with programming and/or scripting languages such as: C# PowerShell
Familiarity with NoSQL databases such as MongoDB.
Exposure to SCOM monitoring tool .
Hands-On Experience in ITIL
Good communication Skills interacting with global teams.
Highly skilled at database design and T-SQL development.
Responsible for database backup and recovery procedures security and database integrity physical data storage design and data storage management.
Configure and manage SQL Security settings.
Make system design recommendations according to Microsoft SQL Server best practices.
Manage database backup recovery & DR planning.
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.
Analyzes SQL query plans and refines complex queries for performance tuning.
Responsible for database migrations and server upgrades.
SQL Server Integration Services (SSIS) and Data Integration: Develop maintain and optimize SSIS packages for ETL (Extract Transform Load) processes of large data into and out of Microsoft SQL Server.
Optimizes data for visualization and Business Intelligence data analysis.
Perform SQL Server integration with enterprise applications.
Experience Required:
Experienced in Database Design and Development to perform the following:
Database design utilizing various objects development such as Packages Procedures Functions Triggers for business logic implementation
T-SQL procedures development compilation and debugging stored Procedures
DB Troubleshooting performance and tuning
Experience in Logical and Physical Database modelling
Experienced in Database Performance Maintenance and Development to perform the following:
Database management including backups recovery and maintenance
Database management for export import and mass data loads
Analyzes and generation of all tables and index statistics
Monitoring and resolving data lock issues
Check all statistics related to memory locks I/O database response time wait events top sessions and background processes
Create indexes to achieve critical dataset response time for time sensitive reports.
Solid understanding of database security concepts and best practices for Microsoft SQL Server databases.
Experience with source control tools (SVN/Git).
Familiarity with programming and/or scripting languages such as: C# PowerShell
Familiarity with NoSQL databases such as MongoDB.
Exposure to SCOM monitoring tool .
Hands-On Experience in ITIL
Good communication Skills interacting with global teams.