Summary:
Evaluate, install, monitor, maintain, and manage the stability, integrity, and efficient operation of in-house databases while ensuring high levels of data quality and availability. This includes gathering and analyzing data in support of systems management, maintenance, and performance.
Job Duties:
- Database monitoring, integration, replication, notification, analysis, tuning, problem resolution, reporting and production support
- Perform SQL server software upgrades; service packs and versions including testing and evaluation of patching strategies
- Coordinate with functional DBA's on database operations, hardware architecture, and security
- Create primary database storage structures, database objects, migration scripts to modify structures and objects
- Design efficient database architecture and maintain performance and tuning
- Optimize database performance, security, and user access
- Coordinate allocation of storage and forecasting space requirements
- Identify long running single queries
- Schedule, automate, execute and monitor job and system performance
- Resolve connectivity issues
- Perform capacity planning
- Modify database structures
- Provide database application support. Schema changes in prod, testing, staging, instances, etc.
- Serve as liaison to vender technical support desks
- Develop backup and recovery procedures
- Establish security roles and database access rights and controls
- Be able to identify blocking transactions within a minute when required
- Provide technical and functional support 24x7
Skills and Qualifications:
- Strong written and verbal communication skills with strong attention to detail
- Daily interaction with customer and multiple data center staff. This is done in person, over the phone, and via email. Will have to carry mobile devices and provide support off hours
- Experience with SQL Server 2008 and SQL 2012 RDMS servers
- Experience supporting SQL, MySQL in Windows environment
- Experience supporting MySQL, PostgreSQL in Linux environment
- Ability to monitor and troubleshoot database performance
- Ability to modify database structures
- Ability to develop backup and recovery procedures
- Ability to coordinate allocation of storage and forecast storage usage
- Ability to perform software upgrades and patching
- Ability to design database architecture
- Intermediate level experience with deployments and support of Amazon Web Services (AWS) services and understanding of private and public cloud concepts
Education and Experience:
- Bachelor's degree in Computer Science, Engineering, or related discipline
- 3-5 years in-depth experience in the design, administration, programming, and support of RDBMS's
- Highly desirable that individual has earned certification as a developer or DBA