Senior Database Administrator

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 administration Experience writing and executing stress tests on databases and services. Experience with cloud services such as AWS EC2and Azure VM and PAAS Knowledge of open-source technologies such as Redis, Hadoop, Cassandra etc. or intimate knowledge/interest in search systems such as Lucene/Solra definite plus Intimate 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 components Experience working with both Nginx and Apache A solid understanding of operational security concepts and strategies and how they relate to Web applications. Experience with OS and application scripting skills Experience with monitoring web server performance Must 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 Administration Experience working in an agile environment with distributed engineering teams. Experience with Postgres, Microsoft SQL Server