Cloud Database Administrator

Hendricks Regional Health - Woburn, MA3.6

Full-timeEstimated: $100,000 - $140,000 a year
EducationSkills
We are seeking an energetic and detail oriented Cloud Database Administrator to 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 specific talent management solutions. As a Cloud Database Administrator, you will be responsible for monitoring and alerting for performance and errors and proactively planning and managing all aspects of database administration! You will also have the opportunity to work closely with all functional groups to ensure smooth customer implementations and compliance with all system standards and directions.

Additional Selling Points:
Opportunity to Build: Bring your creativity to our table! We aren’t just looking for innovative thinkers – we want to see you execute those ideas, too. Watching your idea come to life is a rewarding experience!
Entrepreneurial Culture: You will be working with professionals that value innovative market approaches and strong critical thinking abilities.
Professional Development: Take advantage of the opportunity to attend conferences, expos and client-led events that will elevate you market knowledge.
Team Events: I know. Every organization says they have a great work/life culture BUT . . . Our clients pay us for results (not work hours), we provide complete autonomy to deliver results that seamlessly fit into your lifestyle.

Reporting directly to our Lead Engineer, Cloud Services, this position will work out of our Woburn, MA location.

As a Cloud Database Administrator, you'll have the opportunity to;
Deploy, configure and manage large-scale MySQL and PostgreSQL instances
Monitor and optimize these instances to ensure database performance and manage database capacity planning
Develop and support MySQL/ PostgreSQL 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
Troubleshoot database issues; 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 maintainstrong understanding of the HealthcareSource applications and how we can best leverage the hosting architecture to enhance stability and performance
Acquire and maintain knowledge of internal information systems; help evolve system features, functionality and usability to support company requirements

Requirements:
Intimate knowledge of Linux server systems. Must have good understanding of distributed computing and solid understanding of networking and UNIX system concepts
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
Solid working experience with both Nginx and Apache
Very strong and solid experience of MySQL and PostgreSQL administration. Experience with MySQL/PostgreSQL replication/clustering and partitioning/sharding a must
Experience writing and executing stress tests on databases and services
Experience with cloud services such as AWS EC2
Knowledge of open source technologies such as Redis, Hadoop, Cassandra etc. or intimate knowledge/interest in search systems such as Lucene/Solr a definite plus
A solid understanding of operational security concepts and strategies and how they relate to Web applications
Strong OS and application scripting skills
Experience monitoring web server performance
Excellent understanding of database support, operation and SQL administration
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

Preferred Qualifications:
Bachelor’s degree in Computer Science or related field
5+ years of experience in a directly related position. In addition, at least 5 years of experience in database design, implementation and administration of large complex mission critical databases
High degree of proficiency in Shell scripting for monitoring, regular maintenance and automation of tasks
Certificate in system administration or a degree in a computer science or related field an asset