What are the responsibilities and job description for the Database Administrator position at 4 Staffing Corp?
Database Administrator ( PostgreSQL )
Location : Hybrid / Center City Philadelphia PA
Fulltime / Regular W2 role No C2C
No Visa transfers at this time
Our client is looking for an experienced Database Administrator with expertise in PostgreSQL to oversee the architecture optimization and upkeep of their database systems.
Responsibilities
Database Strategy and Design : Develop and implement scalable and reliable PostgreSQL database solutions tailored to business needs.
Optimization : Analyze and enhance database performance using techniques such as query optimization indexing strategies and resource allocation.
Data Protection : Establish robust backup and recovery mechanisms including replication and disaster recovery solutions.
Security Oversight : Apply and maintain security measures to safeguard sensitive data adhering to industry standards.
System Monitoring : Set up and use tools to continuously track database performance and ensure system reliability.
Automation : Streamline routine operations such as monitoring backups and deployment using automation tools and scripts.
Updates and Maintenance : Plan and execute database migrations upgrades and patches with minimal service disruption.
Documentation : Create comprehensive documentation of database processes configurations and guidelines.
Team Support : Collaborate with developers on query optimization schema design and application integration.
Incident Response : Diagnose and resolve database issues promptly to minimize downtime.
Requirements
Education : Bachelors degree in a relevant field or equivalent professional experience.
Experience : Minimum of 5 years in PostgreSQL database administration.
Technical Expertise :
Deep understanding of PostgreSQL systems and architecture.
Strong skills in SQL tuning and performance enhancements.
Familiarity with highavailability setups including replication and clustering.
Handson experience with backup and recovery strategies.
Proficiency in cloudhosted databases (e.g. AWS RDS Google Cloud SQL).
Automation experience using Bash Python or similar scripting languages.
Knowledge of monitoring tools and their configuration (e.g. pgAdmin Nagios Zabbix).
Awareness of database security practices and compliance standards.
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
What is the career path for a Database Administrator?
Sign up to receive alerts about other jobs on the Database Administrator career path by checking the boxes next to the positions that interest you.
