Junior Database Administrator

Title: Junior Database Administrator  Client: NYC Agency   

Location: Long Island City, NY (Onsite)
Duration: 12 Months
Work Hours: 35 hrs/week

Summary of Position

• We are seeking a highly skilled and experienced Jr. Database Administrator (DBA) to manage, maintain, and optimize our organization's database systems.
• The DBA will be responsible for ensuring the performance, integrity, and security of our databases, supporting critical business operations and data-driven initiatives.
• This role requires a deep understanding of database technologies, strong problem-solving abilities, and a proactive approach to database management.

• Database Installation & Configuration: Install, configure, and upgrade database software (e.g., SQL Server, Oracle, MySQL, PostgreSQL) and related tools.
• Performance Tuning & Optimization: Monitor database performance, identify bottlenecks, and implement tuning strategies (e.g., query optimization, indexing, schema design adjustments) to ensure optimal speed and efficiency.
• Backup & Recovery: Establish and maintain robust database backup and recovery procedures, ensuring data integrity and availability in case of system failures or disasters. Conduct regular recovery tests.
• Security Management: Implement and enforce database security policies, including user access control, encryption, and auditing, to protect sensitive data from unauthorized access.
• Troubleshooting & Support: Diagnose and resolve complex database issues, including connectivity problems, data corruption, and performance degradation. Provide expert support to development teams and end-users.
• Maintenance & Monitoring: Perform routine database maintenance tasks such as patching, space management, and integrity checks. Set up and manage database monitoring tools and alerts.
• Replication & High Availability: Implement and manage database replication, clustering, and other high-availability solutions to minimize downtime and ensure continuous operation.
• Capacity Planning: Monitor database growth and usage, performing capacity planning to ensure sufficient resources for future needs.
• Documentation: Create and maintain comprehensive documentation for database configurations, procedures, and troubleshooting guides.
• Collaboration: Work closely with developers, system administrators, and other IT professionals to support application development, deployments, and infrastructure projects.

Qualifications and Requirements

• Education: Bachelor’s degree in computer science, information technology, or a related field; or equivalent practical experience.
• Experience: 5 years of proven experience as a Database Administrator, managing [mention specific database types, e.g., SQL Server, Oracle, MySQL] in a production environment.

 Technical Skills

• Strong expertise in database management systems (DBMS) such as SQL Server, Oracle, MySQL, PostgreSQL, or others relevant to the organization.
• Proficiency in SQL and scripting languages (e.g., PowerShell, Python, Bash) for automation and database tasks.
• Experience with database backup and recovery tools and strategies.
• Solid understanding of database security principles and best practices.
• Familiarity with operating systems (Windows Server, Linux) as they relate to database environments.
• Knowledge of database performance monitoring and tuning tools.

Soft Skills

• Excellent analytical and problem-solving skills.
• Strong attention to detail and accuracy.
• Ability to work independently and collaboratively within a team.
• Effective verbal and written communication skills.
• Proactive and self-motivated with a strong sense of ownership.