Job Summary and Scope of Responsibility:
The DBA is a member of the MyQ Team and works with the development team to create a high performance, high availability distributed data storage solution.
The Database Administrator shall be responsible for maintaining and developing high performance data storage solutions (NoSQL & SQL), performance tuning, troubleshooting issues, ensuring high availability and data integrity.
The DBA is responsible for implementing policies and procedures that ensure the security and integrity of the MyQ data storage solutions. Ideal candidate should be technically strong in Database Administration, NoSQL technologies, cluster design, high availability, performance tuning, database design, testing, and implement changes to the database environments.
Essential Duties and Responsibilities:
·Monitor and optimize MSSQL and NoSQL database high availability and performance.
·Perform regular capacity planning excercises and strategic evaluation of new technologies to meet MyQ’s growth projections.
·Develop and support production MSSQL and NoSQL database clusters and replication.
·Troubleshoot data storage issues, database integrity issues, performance issues, blocking and deadlocking issues, log issues, maintain database systems availability
·Assists with planning, design, installation and configuration of Couchbase and MS SQL Server
·Work with developers on SQL Server integration Services (SSIS), SQL Server Reporting Services (SSRS)
·Perform day to day Database Administration and maintenance tasks such as backups, restores, recovery models database shrink operations, REINDEX, DBCC CHECKDB
·Replication, Log Shipping and High Availability strategies for MS SQL environments.
·Bachelor degree in Computer Science, Engineering, or related field
A minimum of 4 years’ experience in Database Administration, preferably in a multi-location environment
Knowledge, Skills and Abilities:
·Minimum 5 years of experience as a MSSQL and NoSQL DBA.
·Demonstrated experience with MSSQL and NoSQL database design, implementation, performance tuning, and capacity planning.
·Experience Managing large scale, distributed database systems
·Demonstrated experience with Open Source/Linux, VMWare, Windows development and production environments
·Proficient at using the MSSQL admin tools for issue inspection
·Experienced with performance analysis (IO, CPU, etc) and optimization (indexes, partitions, schema redesign, etc)
·Solid know-how in the area of server monitoring for detection of emerging issues (performance, locking, bad usage)
·Experience with modeling tools to provide more human-readable documentation
·Possessing a solid understanding of Linux - shell scripting but also ability to inspect hardware performance and load indicators.
·Good understanding of master-master replication
·Proactive and comfortable taking full responsibility and ownership of database operations and data integrity
·Experience creating capacity plans and projections
·Experience working with complex environments
·Experience creating disaster recovery plans
·Experience designing workflows
·Possessing creative ability, credibility, self-confidence and Independent
·Good team player with strong analytical, communication, and troubleshooting skills
·Able to work under pressure in multi-tasking situations
·Pro-active, dedicated, committed and responsible
·Strong communicator (including the remote mode)
·Must be flexible and adaptable.
·Familiarity with OLAP interactions with SQL
·Background in NoSQL technologies such as Cassandra, MongoDB or Coachbase.
·Experience with MySQL in the cloud
Travel: A minimum of up to 10% of domestic/international travel may be required.