GDH Consulting Arlington , TX 76004
Sr. SQL DBA
Manages and maintains all Microsoft SQL Server production and non-production databases. Responsible for standards and design of physical data storage, maintenance, access and security administration.
Performs backup and recovery of Database Management Systems, configures database parameters, and prototype designs against logical data models, and defines data repository requirements, data dictionaries and warehousing requirements. Provides technical leadership and operational expertise for the implementation, architecture, design, ongoing support and maintenance of institutional databases and related software systems. Works with multiple IT teams and University departments to develop, maintain, and enhance databases and related applications.
Essential Duties and Responsibilities
1.Develops and maintains a documented database strategy, including standards, design, maintenance, replication, archiving, access and security to support departmental and organizational needs.
2.Manages and maintains all MS SQL Server production and non-production databases, including performing backups, recovery and validation, as well as reporting on database statistics.
3.Proactively manages the database environment to identify and recommend alternatives to poorly coded applications, including consulting with end users to recommend the most appropriate database solution.
4.Applies patches, installs software, manages database environment, monitors performance, and troubleshoots alerts. Optimizes database configurations for optimal configuration, performance and cost.
5.Maintains current knowledge and keeps management informed of products, developments and trends in database management and software.
6.Performs other duties as assigned.
Bachelor's Degree with coursework in computing or information systems and 3-5 years of experience working with various database management systems in database design, testing, implementation, maintenance and administration in a multiple platform environment or the equivalent experience. The following knowledge, skills, and abilities are required:
Knowledge of Database Administration for Microsoft SQL Server in an Enterprise environment.
Extensive knowledge of T-SQL
Experience in troubleshooting and resolving database problems.
Experience in Performance Tuning and Optimization (PTO), profiling, and using native monitoring and troubleshooting tools.
Experience with backups, restores and recovery models.
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MS SQL Server.
Experience in implementing operational automation using scripts.
Knowledge of indexes, index management, and statistics.
Experience working with Linux/Windows servers, including Active Directory
Good communication and documentation skills.
Bachelor's Degree with coursework in computing or information systems and 5+ years of experience working with various database management systems in database design, testing, implementation, maintenance and administration in a multiple platform environment.
Certification is a plus; MCTS, MCITP, or MVP.
Experience with Database Administration for MySQL/PostgreSQL
Performs problem analysis and troubleshooting of the enterprise database infrastructure.
Coordinate support and problem resolution and planning and implementing new solutions and improvements to existing database infrastructure.
Strong background in System Administration
Knowledge of best practices and IT operations in an always-up, always-available service
A strong focus on business outcomes
Comfortable with collaboration, open communication and reaching across functional borders
Monitor, adjust and performs periodical preventive maintenance of system, database and application performance. Design, plan, implement and maintain performance tools.
Interested candidates please send resume in Word format to Please reference job code 54552 when responding to this ad.
GDH Consulting, Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, genetic information, veteran's status or any other category protected by law. In addition to federal law requirements, GDH Consulting, Inc. complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities and/or employees. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, benefits and training.
DBA, SQL Server, Access, Active Directory, database, Documentation, LINUX, Other, Security, Servers, SQL, SQL Server, Storage, T-SQL