Prometric is a trusted test development and delivery provider to more than 300 organizations worldwide. Prometric serves as an industry gatekeeper, ensuring that people legitimately earn the credentials they seek to achieve, and thereby guaranteeing a fair testing experience for all who come through our doors.
Job Overview:
Prometric LLC., is seeking a Sr. SQL Database Administrator with a minimum of 7 years of experience in supporting Microsoft SQL Server high OLTP environment.
This Senior SQL Server DBA will interact with functional representatives, business analysts, and application development/project teams to develop, deploy and support development in QC, Pre-production and Production environment. You will work closely with system engineers in designing backup and recovery strategies, setting up new servers etc.
You will demonstrate your experience using both MS SQL Server Management Studio (SSMS) and T-SQL to configure and manage all aspects of SQL Server instances including database/object creation and updates, query tuning, database backup and recovery, granting server/database/object access, and problem solving. Candidates must also demonstrate knowledge of configuring availability groups including installing and configuring Cluster server, adding and removing databases from availability groups.
- Administration of databases from development through production lifecycles.
- Create, document and implement SQL Server database/development standards.
- Work with customers, end users, project managers, technical architects, and application developers to define requirements and structure for databases
- Design, develop, and integrate highly complex SQL processes and derives logical processes on physical platforms for users and clients
- Availability for after-hours on call support as well as required deployment of production packages during non-peak hours.
- Excellent written and verbal skills and the ability to independently research problems and provide solutions.
Required Skills & Experience:
- Expert in MS-SQL DBA, Expert in Performance Tuning in MS-SQL, Microsoft Platform knowledge, Excellent in Stored Procedure SQL Coding
- Minimum 7+ years technical experience in production SQL Server similar Application support or Development environment
- Experience in installation and patching of SQL Server.
- Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, security issues etc.
- Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler, Extend Events and other related monitoring and troubleshooting tools
- Strong Experience in High availability (Always On, cluster environment)
- Experience in virtualization environment
- Experience with MS SQL Server 2014,2016,2017 and 2019
- Knowledge/experience with DR (Disaster Recovery) drill.
- Experience on database migrations, up-gradation and patching
- Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
- Strong knowledge of backups, restores, recovery models
- Experience in implementing operational automation.
- Strong knowledge on index management, integrity checks, configuration, statistics.
- SQL Development ability to write and troubleshoot SQL Code and design ( stored procedures, functions, tables, views, triggers, indexes, constraints
- Power shell scripting knowledge
- Experience of working within an ITIL framework and/or service-oriented organization
- Good written and verbal communication skills
- Documentation skills for processes and procedures
- Experience with Amazon AWS or Azure
- Experience in migrating databases to Azure.
- Experience in Windows Administration, Active Directory and networking
Prometric is an equal opportunity employer: disability/veteran.
Other details
- Pay Type Salary
- Baltimore, MD, USA
Prometric Inc. is an Equal Opportunity Employer M/F/Vets/Disability