Senior Database Administrator (DBA)

Job Summary

The Senior Database Administrator (DBA) is responsible for providing technical support for the database environment, overseeing the development and organization of the Company’s databases, assessments, implementing new technologies, and providing input on long-term perspectives on the relationship of database technology to business opportunities. Technical support will include owning, tracking, handling requests, resolving incidents, routine maintenance, and development of strategic solutions related to relational databases.

Responsibilities

• Monitor, test, troubleshoot, optimize, prevent, and resolve database-related issues
• Develop and enforce standards and guidelines to optimize the management, documentation, access, usage, migration, consolidation, and safeguarding of Company data
• Achieve a state-of-the-art database environment that meets current and future business objectives by working within architectural standards, software development, and operations teams
• Initiate and perform changes on test, quality assurance, and production
• Provide system/product training to IT members
• Provide and design tools to assist with database management and transaction processing
• Aid capacity assessment and planning by providing a working model of our transaction processing environment
• Develop a methodology for the ongoing assessment of databases
• Develop a security scheme for the database environment, and assist in disaster recovery
• Assist in providing leadership to development, technical support, and operations teams during the design, development, enhancement, production, and implementation of applications
• Develop both the physical and logical database administration functions and assist in the development of our processing database and computing environments
• Assist in defining, maintaining, and reinforcing documented software development lifecycle and release management standards
• Assist software developers in creating, evaluating, and optimizing database queries
• Review, recommend, schedule, implement, and supervise the installation and testing of database-related software
• Work with the development team to plan, coordinate, and implement security measures to safeguard data from accidental or unauthorized usage or modification
• Maintain a superior level of technology-related knowledge by staying abreast of database technology-related changes and advancements
• Work with vendors in evaluating and implementing new technologies as assigned
• Function as a knowledge expert of Microsoft SQL Server systems
• Function as a knowledge expert in Master Data Management
• Function as a knowledge expert in troubleshooting and resolving database issues
• Function as a knowledge expert in Performance Tuning and Query Optimization
• Perform additional duties as assigned

Qualifications

• Bachelor’s Degree in Computer Science or Information Technology, or Associate Degree in Computer Science or Information Technology with equivalent of 5-6 years practical experience
• Preferred Experience: Minimum 8 years practical experience
• IT industry designation preferred in most, if not all, of the following:
• MTA: Microsoft Technology Associate
• MCSA: SQL Server 2012/2014
• MCSA: SQL 2016 Database Administration
• MCSA: SQL 2016 Database Development
• ISACA Cybersecurity Fundamentals
• Advanced technical knowledge in backups, restores, recovery models, maintenance plans, database shrink operations, DBCC commands, clustering, database mirroring, replication
• Advanced technical knowledge with index management, integrity checks, configuration, and patching
• Advanced technical knowledge in writing and troubleshooting SQL Code and design
• Advanced technical knowledge with Data Warehouse technologies, Data Cubes, and Parallel Databases
• Advanced experience in SQL design, planning, development, and performance tools
• Advanced experience in automation and scripting strongly preferred
• Technical understanding of Active Directory
• Technical understanding of operating systems, storage, security delegation, and Kerberos
• Technical understanding of project management principles
• Familiar with applicable data privacy practices and laws
• Willingness to learn, positive service attitude
• Ability to work in a high-demand work environment
• Excellent interpersonal, written, and oral communication skills
• Highly self-motivated, directed with keen attention to detail
• Proven analytical and problem-solving abilities
• Ability to effectively prioritize and execute tasks in a high-pressure environment
• Exceptional customer service orientation
• Extensive experience working in a team-oriented, collaborative environment

Additional Requirements

• Must be available, if required, to periodically assist on a 24-hour on-call basis
• Some travel may be required