SQL Database Developer (RDS Migration) - Los Angeles, California |

SQL Database Developer (RDS Migration)
Back to Job Search
SQL Database Developer (RDS Migration)
Date Posted:  12/8/2021
Job ID:  Job #4557
Employment Type: Contract
Location: Los AngelesCalifornia
Submit Resume
SHARE THIS JOB POST

If you are a Sr. SQL Server Database Developer with hands-on experience migrating on-prem SQL databases to AWS RDS, this is a great opportunity for you! 
STAND 8 provides end to end IT solutions to enterprise partners across the United States and with offices in Morrisville, LA, Atlanta, New York and more.

This position offers full time benefits and longevity for talented individuals who can work on a W2 without sponsorship. If you are interested in enabling and driving innovation in delivering projects using the latest cutting-edge technology to provide growth and solutions for a top financial institution, this is a great opportunity for you! We have a direct connection with the hiring manager and are looking to set up interviews ASAP! 

OVERVIEW

Will focus on migrating a critical SQL Server database on-prem financial business system into the AWS cloud environment using RDS. The SQL database instance will also be upgraded during this process and the resource will be responsible for ensuring that the RDS environment is migrated and all SQL functions, tables, triggers, and stored procedures work properly in the new environment. You will use best practices, standards, policies, methods, tools, and procedures. You will work with the existing DBA team and platform engineers to ensure the business functions are smooth through development, QA, and production. 

RESPONSIBILITIES

SQL server database development that will include stored procedures, triggers, tables, and functions related to financial applications and transactions Refactoring applications to work properly in RDS (AWS) database environments

QUALIFICATIONS

  • Migrating on-prem SQL server (2012) and upgrading SQL environments to new versions
  • Establish, and maintain best practices, standards, policies, methods tools, and procedures
  • Performance tuning procedures to ensure all database environments are running optimally
  • Work with Business & IT owners on data workflows
  • Troubleshoots difficult database application problems
  • Perform other related duties as required and assigned
  • Demonstrate behaviors that are aligned with the organization’s desired culture and values
  • 8+ years of in-depth SQL Server Database development experience 
  • Extensive experience of managing multiple MS SQL 2008/2012/2014/2016 servers on enterprise-class server clusters  
  • Strong self-sufficiency and initiative working on Database projects
  • Experience running databases on AWS' Relational Database Service known as RDS
  • Experience with T-SQL, OLAP, DTS, SSIS, and stored procedures
  • Experience in scripting languages such as Perl, python, or PowerShell
  • Experience in leading and mentoring team members in monitoring and tuning a database to provide a High Availability service
  • Practical experience in managing internal and external Microsoft SQL Server database security 
  • Strong knowledge of Multi-Instance implementations and methodologies
  • Knowledge of SQL Service Broker Understanding of High Availability, Business Continuity, and Disaster Recovery concepts as they relate to Open Systems architecture
  • Excellent written and verbal communication ability
  • Certification or equivalent work experience

#LI-JD1 #LI-REMOTE