Database Administrator (6months)

Woongjin, Inc
Full_time$85k-90k/year (USD)Ridgefield Park, United States

📍 Job Overview

  • Job Title: Database Administrator (6 months)
  • Company: Woongjin, Inc
  • Location: Ridgefield Park, New Jersey, United States
  • Job Type: Contract
  • Category: Database Administration
  • Date Posted: August 1, 2025
  • Experience Level: Mid-Senior level (5-10 years)
  • Remote Status: On-site

🚀 Role Summary

  • Key Responsibilities: Architect, deploy, and maintain mission-critical SQL Server and Oracle databases. Lead PostgreSQL administration efforts, implement high-availability solutions, and optimize database performance.
  • Key Skills: Database Administration, SQL Server, Oracle, PostgreSQL, Linux Administration, High Availability Systems, Scripting, Communication, and Team Leadership.

💻 Primary Responsibilities

🔧 Database Administration & Operations

  • Architect, Deploy, and Maintain: Mission-critical SQL Server and Oracle databases, ensuring optimal performance and availability.
  • Lead PostgreSQL Administration: Efforts including installation, patching, replication, and performance tuning.
  • Implement and Manage High-Availability Solutions: Such as RAC, Data Guard, ASM, and Always On, to ensure minimal downtime and quick recovery.
  • Disaster Recovery Planning and Execution: Conduct regular DR drills and analyze RTO/RPO to minimize data loss and recovery time.

📈 Performance & Capacity Management

  • Monitor and Optimize Query Performance: Conduct regular health checks and capacity planning to ensure optimal database performance.
  • Develop Proactive Alerting and Self-healing Mechanisms: Using monitoring tools like Prometheus, Oracle Enterprise Manager, AWS CloudWatch, or Azure Monitor to automate issue detection and resolution.

🛠 Cloud Infrastructure & Automation

  • Design and Operate Database Deployments: In AWS or Azure using services like RDS/Aurora, EC2, EKS/AKS, ensuring secure and efficient cloud infrastructure.
  • Implement Infrastructure-as-Code: Using tools such as Terraform, CloudFormation, or ARM templates for repeatable, compliant provisioning and deployment.

🛡 Security & Compliance

  • Enforce Database Security Best Practices: Implement access controls, encryption (TDE), auditing, and vulnerability scanning to protect sensitive data.
  • Collaborate with Security and Compliance Teams: To meet SOC 2, GDPR, HIPAA, and other relevant requirements, ensuring data privacy and security.

🤝 Leadership & Collaboration

  • Mentor Junior DBAs: Establish operational standards and runbooks, fostering a culture of knowledge sharing and continuous improvement.
  • Communicate Database Health, Project Status, and Risks: To technical and non-technical stakeholders, ensuring transparency and accountability.
  • Partner with Cross-functional Teams: On schema design, data migration, and performance tuning initiatives, driving collaborative problem-solving and innovation.

🎓 Skills & Qualifications

🎓 Education & Experience

  • Education: Relevant Bachelor's degree in Computer Science, Information Technology, or a related field. Relevant certifications are a plus.
  • Experience: 6+ years managing enterprise-scale database environments, with expertise in SQL, Oracle, and PostgreSQL.

🛠 Required Skills

  • Core Technologies:
    • SQL & Oracle: Expert-level administration, backup/restore, replication, RAC, Data Guard.
    • Linux Administration: RHEL/CentOS/Ubuntu, filesystem tuning, kernel parameters.
  • Highly Available Systems: Proven track record with high-performance, 24x7 database clusters.
  • Scripting: Proficiency in Bash and one higher-level language (Python, Perl, or PowerShell).
  • Communication: Exceptional verbal and written skills; comfortable presenting to executives.
  • Team Leadership: Experience mentoring DBAs and driving process improvements.

🌟 Preferred Skills

  • PostgreSQL: Hands-on administration (logical/physical replication, partitioning, extensions).
  • Public Cloud: Operational experience with AWS RDS/Aurora or Azure SQL/VM deployments.
  • Infrastructure-as-Code: Terraform, CloudFormation, or Azure Resource Manager.
  • CI/CD & DevOps: Database change management with Flyway, Liquibase, or similar tools.
  • Monitoring & Observability: Prometheus/Grafana, Oracle Enterprise Manager, Cloud-native monitoring.

🎯 Additional Desirable Skills

  • Performance schema and in-depth query optimization (e.g., Oracle AWR, SQL Server DMVs).
  • Experience with NoSQL or NewSQL platforms (MongoDB, Cassandra, CockroachDB).
  • Familiarity with containerization (Docker, Kubernetes) for database workloads.
  • Data modeling and ETL processes (SSIS, AWS Glue, Apache Airflow).

📊 Web Portfolio & Project Requirements

  • Portfolio Essentials:
    • Demonstrate expertise in SQL, Oracle, and PostgreSQL administration through case studies or projects.
    • Showcase high-availability solutions, disaster recovery planning, and performance optimization techniques.
    • Display proficiency in scripting and automation through examples of Bash scripts or higher-level language projects.
  • Technical Documentation:
    • Provide detailed documentation of database architecture, schema design, and performance tuning strategies.
    • Include examples of database change management scripts and CI/CD pipeline integration.
    • Demonstrate understanding of security best practices through examples of access controls, encryption, and auditing implementations.

💵 Compensation & Benefits

  • Salary Range: $85,000 - $90,000 per year.
  • Benefits:
    • Medical Insurance
    • Vision Insurance
    • Dental Insurance
    • 401(k)
    • Paid Sick hours

🎯 Team & Company Context

🏢 Company Culture

  • Industry: Woongjin, Inc is a rapidly growing team that provides unique, exceptional, and enhanced services to its clients. They have a strong moral code that includes the service of goodness without expectations of reward and are motivated by a sense of responsibility and servant leadership.
  • Company Size: Medium-sized company with a growing team.
  • Founded: The founding date and company history are not specified.

🌐 Work Environment

  • Office Type: On-site, with a collaborative workspace designed for cross-functional team interaction.
  • Office Location(s): Ridgefield Park, New Jersey, United States.
  • Workspace Context:
    • Collaborative workspace with multiple monitors and testing devices available.
    • Cross-functional collaboration opportunities with developers, designers, and stakeholders.
    • Flexible work schedule with deployment windows, maintenance, and project deadlines consideration.

📄 Application & Technical Interview Process

📝 Enhancement Note:

Given the mid-senior level experience required for this role, candidates can expect a comprehensive interview process focusing on technical expertise, problem-solving skills, and leadership capabilities.

📝 Interview Process:

  1. Technical Assessment: A hands-on evaluation of SQL, Oracle, and PostgreSQL administration skills, focusing on query performance, indexing, and optimization techniques.
  2. System Design & Architecture: A discussion on high-availability solutions, disaster recovery planning, and performance optimization strategies.
  3. Leadership & Team Fit: An assessment of communication, team leadership, and mentoring skills, as well as cultural fit within the organization.
  4. Final Evaluation: A review of the candidate's overall fit for the role, considering technical expertise, problem-solving skills, and leadership capabilities.

📝 Portfolio Review Tips:

  • Case Studies: Prepare detailed case studies demonstrating expertise in SQL, Oracle, and PostgreSQL administration, high-availability solutions, and performance optimization techniques.
  • Scripting & Automation: Showcase proficiency in scripting and automation through examples of Bash scripts or higher-level language projects that improve database performance and efficiency.
  • Security & Compliance: Highlight understanding of security best practices through examples of access controls, encryption, and auditing implementations.

📝 Technical Challenge Preparation:

  • Database Administration: Brush up on SQL, Oracle, and PostgreSQL administration skills, focusing on query performance, indexing, and optimization techniques.
  • System Design & Architecture: Review high-availability solutions, disaster recovery planning, and performance optimization strategies for enterprise-scale database environments.
  • Leadership & Communication: Prepare examples demonstrating exceptional verbal and written communication skills, as well as experience mentoring junior DBAs and driving process improvements.

🛠 Technology Stack & Web Infrastructure

  • Database Management Systems: SQL Server, Oracle, PostgreSQL
  • Operating Systems: Linux (RHEL/CentOS/Ubuntu)
  • Cloud Platforms: AWS, Azure
  • Infrastructure-as-Code: Terraform, CloudFormation, ARM templates
  • Monitoring Tools: Prometheus, Grafana, Oracle Enterprise Manager, AWS CloudWatch, Azure Monitor
  • Scripting Languages: Bash, Python, Perl, PowerShell
  • CI/CD Pipelines: Jenkins, GitLab CI, Azure DevOps
  • Data Modeling & ETL Tools: SSIS, AWS Glue, Apache Airflow

🛡️ Challenges & Growth Opportunities

🔧 Technical Challenges

  • Database Performance Optimization: Develop and implement strategies to improve query performance, indexing, and caching for mission-critical SQL Server and Oracle databases.
  • High-Availability Solutions: Design and manage high-availability solutions, ensuring minimal downtime and quick recovery in case of failures.
  • Disaster Recovery Planning: Conduct regular DR drills and analyze RTO/RPO to minimize data loss and recovery time.
  • Security & Compliance: Enforce database security best practices, collaborate with security and compliance teams to meet relevant requirements, and ensure data privacy and security.

🌱 Learning & Development Opportunities

  • Emerging Technologies: Stay up-to-date with the latest trends and best practices in database administration, cloud infrastructure, and monitoring tools.
  • Public Cloud Experience: Gain operational experience with AWS RDS/Aurora or Azure SQL/VM deployments to expand your skillset and improve cloud infrastructure management.
  • Leadership & Mentoring: Develop your leadership and mentoring skills by guiding junior DBAs and driving process improvements within the team.

💡 Interview Preparation

📝 Technical Questions

  • Database Administration: Prepare for in-depth questions on SQL, Oracle, and PostgreSQL administration, focusing on query performance, indexing, and optimization techniques.
  • System Design & Architecture: Review high-availability solutions, disaster recovery planning, and performance optimization strategies for enterprise-scale database environments.
  • Leadership & Communication: Prepare examples demonstrating exceptional verbal and written communication skills, as well as experience mentoring junior DBAs and driving process improvements.

📝 Company & Culture Questions

  • Company Mission & Values: Research Woongjin, Inc's mission, values, and culture to demonstrate a strong understanding of the organization and its goals.
  • Team Dynamics: Prepare questions to understand the team's structure, collaboration, and communication styles to ensure a good cultural fit.

📝 Portfolio Presentation Strategy

  • Case Studies: Prepare detailed case studies demonstrating expertise in SQL, Oracle, and PostgreSQL administration, high-availability solutions, and performance optimization techniques.
  • Scripting & Automation: Showcase proficiency in scripting and automation through examples of Bash scripts or higher-level language projects that improve database performance and efficiency.
  • Security & Compliance: Highlight understanding of security best practices through examples of access controls, encryption, and auditing implementations.

📌 Application Steps

To apply for this Database Administrator (6 months) position:

  1. Customize Your Portfolio: Tailor your portfolio to highlight relevant SQL, Oracle, and PostgreSQL administration projects, high-availability solutions, and performance optimization techniques.
  2. Optimize Your Resume: Highlight your experience in managing enterprise-scale database environments, scripting proficiency, and exceptional communication skills.
  3. Prepare for Technical Interviews: Brush up on your database administration, system design, and leadership skills, and practice common interview questions and challenges.
  4. Research the Company: Understand Woongjin, Inc's mission, values, and culture to demonstrate a strong understanding of the organization and its goals during the interview process.

⚠️ Important Notice: This enhanced job description includes AI-generated insights and database administration industry-standard assumptions. All details should be verified directly with the hiring organization before making application decisions.

Application Requirements

Candidates must have 6+ years of experience managing enterprise-scale database environments and expert-level administration of SQL and Oracle databases. Proficiency in scripting and exceptional communication skills are also required.