AWS Database Engineer/Administrator

Software Guidance & Assistance, Inc., (SGA), is searching for an AWS Database Engineer/Administrator for a Full-Time assignment with one of our premier Financial Services clients in NYC. Hybrid schedule

Responsibilities :

• Responsible for providing highly technical support and administration of our existing SQL Server and MySQL platforms on AWS. You will also support an on-prem SQL cluster.
• Design, deploy, and maintain scalable, secure, and high-performance cloud database solutions
• Work closely with cross-functional teams to ensure that our cloud database environments support mission-critical applications and drive business success
• Maintain responsibility for database system management, including backups, health monitoring, security, and automation of administration functions.
• Responsible for support tasks, including migrations, implementation, troubleshooting, and maintenance of applications and systems.
• Part of an on-call rotation, ensuring round-the-clock, year-round incident and outage response. This rotation includes working outside regular business hours for code deployments, system changes, and other critical operations.
• Currently, 50% DB Admin vs. 50% DB Engineering. After automation that you will work on, the Engineering % will increase.

Required Skills :

• At least 5+ years of hands-on experience in a database administration and support role.
• At least 3+ years of hands-on experience in AWS environment.
• In-depth understanding of cloud database design principles and best practices within AWS
• Proficiency in writing complex SQL and at least one scripting language (Python, PowerShell, etc).
• Exceptional knowledge of AWS RDS SQL Server, Aurora MySQL, AWS Console, S3, DMS, AWS CLI, and CloudWatch.
• Strong understanding of AWS technologies.
• Participate in on-call rotation, ensuring round-the-clock, year-round incident and outage response
• Participate in rotation that includes working outside regular business hours for code deployments, system changes, and other critical operations.
• Process all support requests within SLA by following procedural requirements.
• Perform initial investigation and troubleshooting of database issues to resolve issues and determine root causes.
• Monitor cloud resource usage and costs, and implement strategies for cost optimization without compromising performance or security.
• Operate in a hybrid work setting, with an expectation to be onsite at our NYC office for 2 days per week and remotely for the remaining days.

Preferred Skills :

• Knowledge of ActiveBatch is a plus
• AWS certifications are a plus
• Python Scripting (within AWS environment)
• Experience in migrating data and code from SQL Server to MySQL.
• Experience with automation and monitoring within AWS.
• Strong problem-solving skills and the ability to work in a fast-paced, collaborative environment.
• Excellent communication skills and a proactive approach to continuous learning and process improvement.
• Ability to work independently and as a team member.

SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at .

SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company to request an accommodation or assistance regarding our policy.