CIYIS is seeking a Senior Database Administrator to assess, design, implement, manage and support our client’s development databases. You will ensure their production databases have minimal downtime and are tuned for optimal performance and response time. You will also be responsible for performing security and maintenance releases. Additionally, you will work closely with a team of developers to define and evolve their data model, support application development, and data analytics.
Responsibilities:
- Manage primary and replica databases across various landscapes.
- Manage database monitoring and SQL releases performed by the managed service provider.
- Document policies, procedures, and technical standards related to disaster recovery planning and execution.
- Work with various stakeholder teams to define strategy and identify performance and coding issues.
- Work with end-users and developers to ensure optimal use of databases and support development efforts via data modeling, performance tuning and TSQL/SSIS development.
- Perform analysis on essential Database Administration procedures including – install, configure, upgrade, back up, and monitor databases.
- Serve as point-of-contact for any defined database questions on the team regarding performance, security, or ongoing maintenance.
- Work with application developers and systems engineers to troubleshoot and optimize queries, and performance bottlenecks for current and future implementations.
- Engage with Network Administration/operations and virtualization engineers.
- Integrate instances with enterprise monitoring and alerting tools.
- Refine processes to improve high performance and high availability.
- Create instrumentation/monitoring solutions to gain insight into existing application and database performance and to understand emerging issues.
- Maintain and create automation and deployment software and tools relating to database infrastructures.
Technical Qualifications:
- 5+ years as MSSQL production DBA including experience with design, implementation, backup and recovery, monitoring, and performance tuning.
- 5+ years of experience with 24x7 support and troubleshooting production related database issues. ·
- 5+ years of experience managing databases in virtual and cloud environments (AWS, Azure, Redshift, VMware, RDS, EC2) ·
- Exposure to the management of non-relational database servers such as AWS DynamoDB, Redshift, Redis, Couch, Mongo or other No-SQL platforms.
- Experience in MySQL database management and scripting in a professional environment. ·
- Recent experience implementing multilayer, high-availability replication topologies.
- Exposure to NoSQL platforms and conceptual understanding.
- Experience in one or more programming languages such as: .Net, PHP, Python, Ruby, Java, C, C++, C#, JavaScript.
- Understand various virtualization approaches and creating virtualized environments.
- Ability to manage multiple projects with competing priorities in a fast-paced environment.
- Experience with Database sharing and partitioning.
- Experience with designing and implementing high-availability database features, utilizing various replication and disaster recovery methodologies.
- Experience implementing database schema changes in a live production environment requiring minimal downtime and zero performance impact.
- Experience defining and implementing database management tools across the entire database platform to ensure database performance and stability is maximized across the entire organization.
- Experience with managing the full life-cycle of database schema design and implementation, which includes script management from development through production releases.
- Experience with establishing and implementing database security and backup retention policies.
- Familiarity with ITIL concepts.
- Microsoft Certified Database Administrator (MCDBA). MCTS, MCITP, MCM certs.
Educational & Work Qualifications:
- 4 Year degree in Computer Sciences, Information Technology, or equivalent experience.
- U.S. Citizen.
CIYIS is an Equal Opportunity Employer and all Qualified Applicants will receive consideration for employment without regard to Race, Color, Religion, Sex, National Origin, Disability Status, Protected Veteran Status or any other Characteristic Protected by Law.