Oversee database design, administration, security, performance, availability, backup, and recovery across cloud and on-premises environments. Install, configure, upgrade, patch, monitor, and troubleshoot PostgreSQL databases; administer Amazon RDS and Aurora; support migrations and data integration using AWS services. Develop database standards, optimize performance, maintain integrity controls, and collaborate with architecture, engineering, security, and organizational stakeholders.
Overview
The Database Administrator oversees the design, implementation, operation, security, and integrity of production, non-production, and redundant database environments across cloud and on-premises implementations. This role will maintain reliable database services, guide database standards and strategy, support backup and recovery readiness, and advise technical and organizational leaders on database capabilities and improvements.
The base salary range for this position is $95,178-$149,565.
Actual pay will be determined based upon a candidate’s job-related knowledge, skills, education, experience, geographic location, and may include other job-related factors such as certification(s), professional licensure, or internal equity considerations.
Responsibilities- Oversees daily operations of production, non-production, and redundant database environments across internal and customer environments.
- Formulates and maintain database management policies, procedures, and standards, and monitor transaction activity and database utilization.
- Reviews database designs and system integrations and recommend enhancements or improvements.
- Develops, manages, and tests backup and recovery plans to confirm that procedures function properly.
- Maintains database security and integrity controls.Installs, configures, upgrades, patches, monitors, and troubleshoots PostgreSQL database environments.
- Optimizes PostgreSQL performance through query optimization, index strategy, vacuum and analyze tuning, and database parameter configuration.
- Administers Amazon RDS and Amazon Aurora for PostgreSQL and supports database migration and data integration activities using AWS Database Migration Service and AWS Glue.
- Monitors database performance, resource utilization, availability, and operational health, and take appropriate corrective action.
- Collaborates effectively with architecture, engineering, security, and other stakeholders while organizing work for timely completion.
- Bachelor’s degree in a computer-related field from an accredited college or university and five or more years of related experience, or an equivalent combination of education, certification, training, and experience.
- Hands-on experience with PostgreSQL database administration, including installation, configuration, upgrades, and patching.
- Strong expertise in PostgreSQL performance tuning, including query optimization, index strategy, vacuum and analyze tuning, and parameter configuration.
- Experience monitoring and troubleshooting PostgreSQL database performance, resource utilization, and availability.
- Experience administering Amazon RDS and Amazon Aurora for PostgreSQL.
- Strong SQL development skills across online transaction processing and analytical data platforms.
- Ability to communicate effectively in English, both orally and in writing, and to follow complex oral and written instructions.
- Ability to organize work for timely completion and maintain effective, cooperative working relationships.
- Experience with AWS Lake Formation and data lake deployment and administration.
- General understanding of Amazon Redshift architecture and service model, including role-based access control, user and group management, and security permissions.
- Experience with AWS Glue and AWS Database Migration Service.
- Database certification in PostgreSQL or Oracle preferred.
Working Conditions:
- Flexible work hours in a fun collaborative environment
- Must have reliable internet connection at all times
- Must have the ability to travel, as needed for company meetings
Similar Jobs
Information Technology • Insurance • Software
Administer and optimize enterprise SQL Server databases across on-premises and AWS environments. Responsibilities include performance tuning, query optimization, high availability and disaster recovery, replication, backup and recovery, migrations, security, automation, monitoring, and production support. The role collaborates with application, SRE, and cloud teams, provides architectural guidance, supports database reliability, and participates in a 24x7 on-call rotation.
Top Skills:
Amazon Ec2Amazon RdsAmazon RedshiftAnsibleAurora PostgresqlAWSGitlabKubernetesMicrosoft Sql ServerOraclePerformance MonitorPostgresPowershellPythonServicenowSql ProfilerSsrsT-SqlTerraform
Information Technology • Consulting • Defense
Administer and maintain Oracle RAC clusters, databases, EBS, and Fusion Middleware environments supporting a Marine Corps ERP. Responsibilities include patching, security compliance, monitoring, performance tuning, instance cloning, upgrades, documentation, availability, and environment support. The role requires extensive Oracle EBS and database administration experience, Security+ certification, U.S. citizenship, and the ability to pass a T5 background investigation.
Top Skills:
AmpIavaLoad BalancingOracle Access ManagerOracle Database 11GOracle Database 12COracle Database 19COracle E-Business Suite R12.2Oracle Enterprise Manager 13COracle Enterprise Manager Cloud ControlOracle Fusion MiddlewareOracle Internet DirectoryOracle ObieeOracle RacOracle RdbmsOracle SoaStigs
Healthtech • Information Technology
Responsible for administering, securing, tuning, migrating, and maintaining relational and non-relational databases across internal systems and client environments. The role includes capacity planning, backup and recovery, SQL optimization, performance monitoring, cloud database management, data pipeline maintenance, and troubleshooting. The administrator serves as a data management subject matter expert, supports deployment projects, recommends system improvements, presents metrics, and collaborates with development, managed services, partners, and customers.
Top Skills:
ActivemqAmazon RedshiftApache KafkaAws RdsAzure Event HubsAzureMicrosoft Sql ServerMongoDBNetSuiteOracleOracle Cloud InfrastructurePostgresSnowflakeSQL
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
