Junior Database Administrator

Job Title:Junior Database Administrator

Duration: 12 months extension possible based on needs and performance

Location:Long Island City NY 11101. Need local and on-site interviews will be required

Job Summary:

Summary of Position:

• We are seeking a highly skilled and experienced Jr. Database Administrator (DBA) to manage maintain and optimize our organizations 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.

Job Duties:

• 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: Bachelors 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.