Overview
Objective :
The Senior Database Administrator will join our team and play a leading role in defining, developing, and documenting the structure and security of production services and databases for our healthcare solutions.
Description :
As a Sr. Database Administrator, you will be responsible for monitoring and alerting for performance and errors while proactively planning and managing all aspects of database administration. You will have the opportunity to work closely with all functional groups to ensure smooth customer implementations and compliance with all system standards and directions.
Duties & Responsibilities
Duties :
- Deploy, configure, and manage large-scale MySQL, PostgreSQL, Microsoft SQL Server
- Monitor and optimize these instances to ensure database performance and manage database capacity planning.
- Develop and support MySQL, PostgreSQL, Microsoft SQL Server database replication across multiple data centers.
- Manage the backup and recovery procedures for all databases within the production and development environments.
- Monitor and update disaster recovery plan where required.
- Build database schema, tables, procedure, and permissions.
- Install and test upgrades and patches.
- Perform database troubleshooting, database tuning, and capacity planning.
- Maintain database systems availability and scalability.
- Develop and optimize database design for new applications.
- Provide technical expertise to ensure the successful operation of the hosted environment.
- Perform software installations, upgrades and migrations as required.
- Play a core role in ensuring code updates are planned and implemented smoothly following all operational procedures.
- Ensure that all tickets are properly documented, prioritized, and completed according to our Service Level Agreements with our customers.
- Acquire and maintain knowledge of internal information systems; help evolve system features, functionality, and usability to support company requirements.
Skills Required
Skills Required :
Strong and solid experience of Microsoft SQL Server, and PostgreSQL administration.Experience with PostgreSQL, Microsoft SQL Server replication / clustering and partitioning / sharding a must.Excellent understanding of database support, operation, and SQL administrationExperience writing and executing stress tests on databases and services.Experience with cloud services such as AWS EC2and Azure VM and PAASKnowledge of open-source technologies such as Redis, Hadoop, Cassandra etc. or intimate knowledge / interest in search systems such as Lucene / Solra definite plusIntimate knowledge of Linux server systems. Must have good understanding of distributed computing and solid understanding of networking and UNIX and Windows system.A solid understanding of networking / distributed computing environment concepts; understands principles of routing, client / server programming, the design of consistent network-wide file system layouts, high traffic / high availability networking concepts like load balancing, clustering.Experience working with load balancing technologies and large-scale web server farms. Thorough grasp of web application architecture, including TCP / IP, HTTP, load balancing, caching strategies and other common componentsExperience working with both Nginx and ApacheA solid understanding of operational security concepts and strategies and how they relate to Web applications.Experience with OS and application scripting skillsExperience with monitoring web server performanceMust possess excellent written and verbal communication and be able to interact effectively and professionally with other teams and Engineers.Ability to rapidly assess, analyze and resolve complicated issues with little initial information or direction and with varying degrees of ambiguity.Able to work in a super-fast-paced environment and resolving multiple interrupt-driven priorities simultaneously is a must.Qualifications Required :
Bachelor's or Master’s degree in CSE, IT or a related field and 6-8 years’ experience in Database AdministrationExperience working in an agile environment with distributed engineering teams.Experience with Postgres, Microsoft SQL Server