Changing People, Processes & Perceptions.
Database Administrator
Location
United States
Posted
3 days ago
Salary
0
Seniority
Mid Level
No structured requirement data.
Job Description
Database Administrator
InstantServe LLC
Role Description The Database Administrator is responsible for managing, maintaining, and optimizing PostgreSQL databases and OpenSearch Indexes hosted on Amazon Web Services (AWS). This role partners closely with application development and architecture teams to ensure high availability, performance, and compliant access controls across data platforms. - Database deployment & lifecycle management: Provision, configure, and maintain PostgreSQL databases on AWS RDS, including instance sizing, parameter group configuration, and database creation. - Performance monitoring & optimization: Monitor database health and tune performance (query analysis, indexing, vacuum/analyze strategies, parameter tuning) to meet reliability and latency targets. - Backup, recovery & resiliency: Implement and validate backup/restore procedures using AWS RDS capabilities and PostgreSQL features; support disaster recovery planning and testing. - Security & compliance: Administer database roles, privileges, authentication patterns, and encryption (in transit/at rest) aligned to organizational security requirements and AWS best practices. - Upgrades & patching: Plan and execute PostgreSQL version upgrades and RDS patching with minimal downtime; maintain compatibility and supportability. - Automation & infrastructure support: Automate recurring DBA activities using AWS Command Line Interface (CLI), Infrastructure as Code (IaC) such as AWS CloudFormation/Terraform, and scripting. - Incident response & on-call: Respond to database incidents, conduct root-cause analysis, and implement preventative measures; participate in on-call rotation as needed. - Documentation & reporting: Maintain runbooks, configuration documentation, and produce periodic health, capacity, and performance reports. Qualifications - 1+ years of hands-on experience supporting software development efforts - Active, fully adjudicated Secret clearance - Proven experience administering AWS RDS for PostgreSQL (performance, backups, upgrades, monitoring). - Strong SQL skills and ability to diagnose performance bottlenecks (execution plans, indexing strategies). - Experience implementing backup/recovery strategies and validating restore procedures. - Working knowledge of AWS monitoring and security fundamentals (e.g., Amazon CloudWatch, AWS IAM, encryption, network controls). - Proficiency with Linux/Unix and scripting/automation (e.g., Bash, Python). - Experience provisioning and maintaining OpenSearch access controls (RBAC / least privilege), including troubleshooting permissions issues. - Strong communication skills; able to translate technical constraints into clear guidance for engineers and stakeholders.
Related Guides
Related Categories
Related Job Pages
More Database Administrator Jobs
• Monitoring and Support for Analytical Data Platforms: Perform installation, monitoring, configuration and operational support of Big Data/Data Warehouse platforms (such as Teradata Vantage) and corporate databases of the Central Bank of Brazil. • Execution of Routines and Permissions Management in DBMS: Execute queries and DML/DDL commands not controlled by automated models, create access credentials, maintain scripts, and grant or revoke database permissions. • Performance Analysis and Diagnosis: Investigate and diagnose errors, failures or slowdowns in applications that access the databases, handle support tickets and provide support to the solution infrastructure.
Role Description The MEP VDC Fabrication Database Coordinator is a client-facing technical specialist responsible for developing, maintaining, and supporting Autodesk Fabrication databases and content for MEP and specialty trade contractors. This role involves: - Working closely with client VDC teams, BIM managers, detailers, estimators, fabrication personnel, and project stakeholders. - Creating and managing ITM content. - Configuring and improving fabrication databases. - Troubleshooting technical issues. - Performing quality assurance testing. - Maintaining clear documentation. The ideal candidate combines hands-on Autodesk Fabrication expertise with strong problem-solving, organizational, and communication skills to deliver reliable, standardized, and scalable database solutions that support client-approved fabrication workflows and business objectives. Qualifications - 3+ years of experience with Autodesk Fabrication content, databases, or MEP fabrication workflows. - Hands-on experience creating, modifying, testing, and supporting Autodesk Fabrication ITM parts. - Proficiency with one or more Autodesk Fabrication products, including CADmep, CAMduct, ESTmep, or Revit Fabrication Parts. - Working knowledge of Autodesk Fabrication databases, services, specifications, materials, connectors, and related content configurations. - Understanding of MEP systems and construction workflows, including HVAC, piping, plumbing, electrical, or specialty trades. - Experience interpreting manufacturer documentation, product specifications, fabrication standards, and technical drawings. - Strong troubleshooting, quality assurance, and problem-solving skills. - Excellent communication, documentation, organization, and client-service skills. - Ability to manage multiple priorities while working independently and collaboratively in a team environment. - Strong attention to detail and commitment to delivering accurate, maintainable solutions. Requirements - 5+ years supporting MEP contractors, fabrication shops, detailing departments, or VDC teams. - Experience managing multiple Autodesk Fabrication databases across clients or business units. - Experience with both sheet metal and piping fabrication content. - Experience integrating Autodesk Fabrication databases with Revit fabrication workflows. - Familiarity with Design Line, spooling, estimating, CAM output, fabrication, and installation workflows. - Experience with database migrations, software upgrades, content standardization, and configuration deployment. - Knowledge of BIM coordination, database governance, version control, and quality management practices. - Experience providing client training, technical support, mentoring, or consulting services. - Autodesk certifications or related BIM, VDC, fabrication, or trade credentials. Benefits - Generous and flexible time off (FTO), plus eight paid holidays. - Company-sponsored benefits include: - Group health insurance with nominal employee contribution. - Employer-paid short- and long-term disability coverage. - Access to optional benefits through a cafeteria plan, including dental, vision, life insurance, wellness reimbursement program, and other supplemental benefits. - Employer match of employee HSA contributions, dollar-for-dollar up to the IRS limit. - 401(k) with company match of up to 4% of base salary. - *Our company is currently unable to sponsor work visas. Candidates must be legally authorized to work in the United States without sponsorship. - Symetri is an Equal Opportunity Employer as to all protected groups, including protected veterans and individuals with disabilities.
• Designs, Installs, maintains and controls the organization's production and non-production databases. • Provides on-call support for production environments. • Plays a key role in ensuring the availability, performance and security of the databases.
• Working with Business Analysts on database design changes needed per requirements • Creating logical and physical data models from user requirements • Providing database support for development and deployment of database scripts in Development and Test environments. • Works in conjunction with other teams in the database administration of the Pre-Production and Production environments • Creating scripts for tables and other objects like triggers and procedures is our day-to-day • Performing data migrations • Maintaining data standards, including adherence to the Data Protection Act • Communicating regularly with technical, applications, and operational staff to ensure database integrity and security • Assisting customers with issues related to applications involving issues with PL/SQL code, UNIX shell scripts, cron job code running in development and production environments • Developing Oracle stored procedures, packages, functions, and triggers in support of new applications being deployed • Recommending solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications • Implementing new releases and completing maintenance requirements • Monitoring performance and managing parameters to provide fast query responses to front-end users • Ensuring that storage, archiving, back-up and recovery procedures are functioning correctly • Support for writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata) • Ability to support the updating of Security Artifacts and environment Vulnerability Analysis • Controlling access permissions and privileges



