Job Description
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.
Job Tags
Full time, Part time, Internship, Seasonal work,