Recruit Professional Services
https://cdn.haleymarketing.com/templates/101941/sm-logo-200x200.png
http://www.recruitps.com
http://www.recruitps.com
USD
140000
YEAR
true
MSSQL and PostgreSQL DBA
Posted: 07/17/2023
2023-07-17
2024-10-07
Employment Type:
Direct Hire
Industry: Other Area(s)
Job Number: 563
Pay Rate: 140,000
Job Description
Seeking a highly skilled and experienced Database Administrator with a strong background in managing MSSQL and PostgreSQL databases. The ideal candidate will have expertise in developing and optimizing SQL queries, designing complex stored procedures, and ensuring the efficient installation, configuration, and troubleshooting of PostgreSQL. Additionally, knowledge and experience with Amazon AWS services and proficiency with Git/GitHub are desired. The successful DBA candidate will play a critical role in maintaining the stability, security, and performance of our databases.
This position is able to be remote in the United States or hybrid, working out of our NYC office. What You'll Do:
This position is able to be remote in the United States or hybrid, working out of our NYC office. What You'll Do:
-
- Manage and administer MSSQL and PostgreSQL databases, ensuring their stability, availability, and performance.
- Develop and optimize SQL queries to retrieve and manipulate data efficiently, improving system performance and response times.
- Design and maintain complex stored procedures, triggers, and views to meet business requirements, ensuring data consistency and integrity.
- Install, configure, and monitor PostgreSQL databases, addressing any issues or errors that arise.
- Implement and maintain database security measures, including user access controls, authentication mechanisms, and data encryption.
- Develop and execute backup and recovery strategies, minimizing the risk of data loss and ensuring business continuity.
- Utilize Amazon AWS services, such as EC2 and RDS, for database deployments, monitoring, and scaling to meet business demands.
- Collaborate with cross-functional teams, including developers and system administrators, to troubleshoot and resolve database-related issues promptly.
- Utilize Git/GitHub for version control and collaborative development, ensuring proper code management and team coordination.
- Assist in data warehouse design and implementation, including ETL processes and reporting requirements.
- Stay updated with the latest advancements and best practices in MSSQL, PostgreSQL, Amazon AWS, and related technologies.
-
- Bachelor’s degree in computer science, Information Technology, or a related field.
- Proven experience as a Database Administrator, with a focus on MSSQL and PostgreSQL databases.
- Strong proficiency in SQL query optimization and performance tuning.
- Expertise in designing and maintaining complex stored procedures, triggers, and views.
- Experience in the installation, configuration, and troubleshooting of PostgreSQL databases.
- Understanding and practical experience with Amazon AWS services, such as EC2, RDS, and S3.
- Familiarity with Git/GitHub for version control and collaborative development.
- Knowledge of database security principles and best practices.
- Strong analytical and problem-solving skills.
- Excellent communication and interpersonal skills.
- Ability to work effectively in cross-functional teams and collaborate with stakeholders.
-
- Relevant certifications, such as Microsoft Certified: Azure Database Administrator Associate or PostgreSQL Certified Professional
Meet Your Recruiter
![](https://cdn.haleymarketing.com/images/team-members/101941/thumbs/teammember_thumb_small2x_square-A0E4E20D-2CD6-3E3D-B6DD-C7ECB854C926.jpg)
Jason Destro
Over 20 years’ of recruiting experience with hands-on recruiting and placement of I.T. professionals (Full Time, Temp 2 Perm, & Contingent) in the NJ/NY/CT/PA marketplace for a wide variety of today's demanding IT skill sets. Focused on delivering exceptional service by understanding client’s objectives and goals.
Share This Job:
Related Jobs:
Login to save this search and get notified of similar positions.About New York, NY
Discover exciting job opportunities in the vibrant area around New York, New York! With its iconic skyline, diverse cultural scene, and endless career growth prospects, the Big Apple and its surroundings promise an unparalleled work-life experience. Nestled between Broadway theaters, world-class art galleries like The Metropolitan Museum of Art, and globally renowned cuisine spots in Little Italy and Chinatown, finding your dream job in New York is your gateway to thriving in a city that never sleeps. Embrace the energy of Times Square, catch a game with the Yankees at Yankee Stadium, or unwind in the serenity of Central Park. Explore our job listings today and unlock your potential in the heart of opportunity.