Job description

Position Title: Junior Database Administrator (Jr. DBA) Location: Long Island City, NY (Hybrid - onsite presence required) Clearance Requirements: None Position Status: Contract Pay Rate: $30-$37/hour (based on experience) Position Description Client is seeking a Junior Database Administrator (Jr. DBA) to help manage, maintain, and optimize enterprise database systems supporting critical public health and operational initiatives. This role is part of the agency's Data Modernization Initiative (DMI) - a citywide effort to transform siloed, legacy data systems into connected, resilient, and scalable cloud-based environments. The Jr. DBA will play a key role in improving database performance, ensuring data integrity and security, and supporting data-driven decision-making that impacts millions of New Yorkers. The ideal candidate will be a technically proficient, detail-oriented, and proactive problem solver with hands-on experience in SQL databases, cloud environments, and performance tuning. Key Responsibilities • Database Administration: Install, configure, and maintain database systems such as SQL Server, Oracle, MySQL, or PostgreSQL. • Performance Optimization: Monitor and fine-tune database performance, optimize queries and indexes, and adjust schema designs for efficiency. • Backup & Recovery: Implement robust backup and recovery strategies; conduct routine integrity checks and recovery drills. • Security Management: Apply database security policies, manage user access, encryption, and auditing to ensure compliance with data privacy standards. • Troubleshooting & Support: Diagnose and resolve performance, connectivity, and data integrity issues; provide technical support to development and infrastructure teams. • Maintenance & Monitoring: Perform regular database patching, capacity planning, and performance monitoring using enterprise tools. • High Availability & Replication: Implement replication, clustering, and other high-availability solutions to ensure continuous system uptime. • Documentation: Maintain detailed documentation for database configurations, policies, and troubleshooting procedures. • Collaboration: Partner with developers, system administrators, and cybersecurity teams to support system enhancements and data integrations. Required Skills & Qualifications • Education: Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent practical experience). • Experience: Minimum of 2 years of hands-on database administration experience in a production environment. • Technical Expertise: • Proficiency with SQL Server, Oracle, MySQL, or PostgreSQL. • Strong knowledge of SQL, query optimization, and scripting (PowerShell, Python, or Bash). • Experience with database backup, recovery, and performance monitoring tools. • Solid understanding of database security best practices and user access management. • Familiarity with Windows Server and/or Linux environments. • Exposure to cloud database platforms such as Azure SQL Database or AWS RDS is a plus. • Soft Skills: • Strong analytical, troubleshooting, and documentation skills. • Excellent verbal and written communication abilities. • Ability to work both independently and as part of a collaborative IT team. • Highly organized, detail-oriented, and self-motivated. About Seneca Resources At Seneca Resources, we are more than just a staffing and consulting firm - we're a trusted career partner. With offices across the U.S. and partnerships spanning Fortune 500 companies and public sector organizations, we connect professionals with impactful opportunities that help advance their careers. We offer competitive pay, comprehensive benefits (health, dental, vision, 401(k)), and a dedicated team that supports your success every step of the way. Seneca Resources is proud to be an Equal Opportunity Employer, committed to fostering a diverse and inclusive workplace where all qualified applicants are encouraged to apply.

Requirements