ESG
Overview
Join to apply for the
Senior Database Administrator
role at
ESG This is a hybrid position and we expect to be onsite for 2-3 days per week at our Norwell, MA office. Position Summary
You have the unique opportunity to work with modern and highly scalable global systems. You must be an avid technology enthusiast with experience supporting large and dynamic database environments, both physical and cloud-based servers in a production environment and can understand, automate, and troubleshoot large and complex data infrastructure. Position Responsibilities
Design, implement, and optimize Oracle and PostgreSQL database architectures. Collaborate with application teams to understand their requirements and ensure database solutions support application performance and reliability. Develop migration strategies, testing plans, and rollback procedures. Monitor, troubleshoot, and optimize database performance and scalability. Implement security protocols and ensure compliance with data governance standards. Lead end-to-end migrations from Oracle to PostgreSQL, ensuring minimal downtime and data integrity. Automate routine database management tasks and develop scripts for maintenance and deployment. Lead efforts for database backup, recovery, and disaster recovery planning. Document database schemas, configurations, and procedures. Mentor junior team members and foster best practices across the database team. Establish and enforce database standards, policies, and procedures. Review and optimize SQL and PL/SQL code for performance improvements. Participate in capacity planning and performance tuning to support business growth. Stay current with emerging database technologies, trends, and best practices, and recommend innovative solutions. Act as a technical lead during cross-team projects involving database design, migration, or integration. Provide expert guidance on cloud database architecture, especially AWS RDS and other cloud platforms. Experience
Strong knowledge of SQL, PL/SQL, and PostgreSQL extensions. Extensive experience with Oracle, SQL Server and PostgreSQL (RDS and Aurora) database management. Proven experience in performance tuning, query optimization, and high-availability solutions. Experience with cloud database platforms, particularly AWS RDS, or other cloud-based database services, is highly preferred. Demonstrated success in leading Oracle to PostgreSQL migrations, with a focus on application-focused migrations. Familiarity with cloud architecture, security, and scalability best practices. Excellent problem-solving, leadership, and communication skills. Ability to lead projects and work collaboratively across teams. Experience with Aurora Global Databases to replicate and promote clusters across multiple AWS regions. Experience with complex Oracle and PostgreSQL system configuration and tuning for best performance. Experience supporting enterprise SaaS environments including production, test, and pre-production. Maintain relationships with vendors and proactively manage trouble tickets, and follow through to ensure 3rd party work is completed timely, accurately, and cost effectively. Knowledge of LAN and WAN networks, TCP/IP, DNS, DHCP and HTTP. Knowledge and experience with Containerization (Kubernetes/Docker/etc). Familiar with ITSM tools and processes ITIL Incident/Problem/Change management using Atlassian Jira and/or Confluence. Technical knowledge of several monitoring and analytics tools such as PRTG, DataDog/NewRelic, Icinga, SolarWinds, Splunk, and AWS CloudWatch. Experience maintaining a secure production environment. Ability to plan, prioritize, and hold self and others accountable to SLAs and schedules. Effective oral and written communication skills. Flexible, versatile, and adaptable to day-to-day activities. On call Support and maintenance as needed over weekdays and weekends. Education
Bachelor's degree in Computer Science, Information Technologies or related field, or an equivalent combination of experience, education, and training. Preferred Skills
Certifications such as Oracle Certified Professional (OCP), PostgreSQL Certified Professional, or relevant cloud certifications (AWS Certified Solutions Architect). Experience with automation tools and scripting languages (Bash, Python, etc.). Strong understanding of application development lifecycle and DevOps practices in database management. Seniority level
Not Applicable Employment type
Full-time Job function
Information Technology Industries
IT Services and IT Consulting End of description. #J-18808-Ljbffr
Join to apply for the
Senior Database Administrator
role at
ESG This is a hybrid position and we expect to be onsite for 2-3 days per week at our Norwell, MA office. Position Summary
You have the unique opportunity to work with modern and highly scalable global systems. You must be an avid technology enthusiast with experience supporting large and dynamic database environments, both physical and cloud-based servers in a production environment and can understand, automate, and troubleshoot large and complex data infrastructure. Position Responsibilities
Design, implement, and optimize Oracle and PostgreSQL database architectures. Collaborate with application teams to understand their requirements and ensure database solutions support application performance and reliability. Develop migration strategies, testing plans, and rollback procedures. Monitor, troubleshoot, and optimize database performance and scalability. Implement security protocols and ensure compliance with data governance standards. Lead end-to-end migrations from Oracle to PostgreSQL, ensuring minimal downtime and data integrity. Automate routine database management tasks and develop scripts for maintenance and deployment. Lead efforts for database backup, recovery, and disaster recovery planning. Document database schemas, configurations, and procedures. Mentor junior team members and foster best practices across the database team. Establish and enforce database standards, policies, and procedures. Review and optimize SQL and PL/SQL code for performance improvements. Participate in capacity planning and performance tuning to support business growth. Stay current with emerging database technologies, trends, and best practices, and recommend innovative solutions. Act as a technical lead during cross-team projects involving database design, migration, or integration. Provide expert guidance on cloud database architecture, especially AWS RDS and other cloud platforms. Experience
Strong knowledge of SQL, PL/SQL, and PostgreSQL extensions. Extensive experience with Oracle, SQL Server and PostgreSQL (RDS and Aurora) database management. Proven experience in performance tuning, query optimization, and high-availability solutions. Experience with cloud database platforms, particularly AWS RDS, or other cloud-based database services, is highly preferred. Demonstrated success in leading Oracle to PostgreSQL migrations, with a focus on application-focused migrations. Familiarity with cloud architecture, security, and scalability best practices. Excellent problem-solving, leadership, and communication skills. Ability to lead projects and work collaboratively across teams. Experience with Aurora Global Databases to replicate and promote clusters across multiple AWS regions. Experience with complex Oracle and PostgreSQL system configuration and tuning for best performance. Experience supporting enterprise SaaS environments including production, test, and pre-production. Maintain relationships with vendors and proactively manage trouble tickets, and follow through to ensure 3rd party work is completed timely, accurately, and cost effectively. Knowledge of LAN and WAN networks, TCP/IP, DNS, DHCP and HTTP. Knowledge and experience with Containerization (Kubernetes/Docker/etc). Familiar with ITSM tools and processes ITIL Incident/Problem/Change management using Atlassian Jira and/or Confluence. Technical knowledge of several monitoring and analytics tools such as PRTG, DataDog/NewRelic, Icinga, SolarWinds, Splunk, and AWS CloudWatch. Experience maintaining a secure production environment. Ability to plan, prioritize, and hold self and others accountable to SLAs and schedules. Effective oral and written communication skills. Flexible, versatile, and adaptable to day-to-day activities. On call Support and maintenance as needed over weekdays and weekends. Education
Bachelor's degree in Computer Science, Information Technologies or related field, or an equivalent combination of experience, education, and training. Preferred Skills
Certifications such as Oracle Certified Professional (OCP), PostgreSQL Certified Professional, or relevant cloud certifications (AWS Certified Solutions Architect). Experience with automation tools and scripting languages (Bash, Python, etc.). Strong understanding of application development lifecycle and DevOps practices in database management. Seniority level
Not Applicable Employment type
Full-time Job function
Information Technology Industries
IT Services and IT Consulting End of description. #J-18808-Ljbffr