SQL Database Developer (RDS Migration)

08 Nov 2024

Vacancy expired!

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 is a strategic services and staffing company that partners great talent with amazing opportunities in technology solutions for all industries. We work with top tier client-partners across the United States and have offices in Los Angeles, Atlanta, New York, New Jersey, Raleigh, and Morro Bay.

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!

OVERVIEWWill 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.

RESPONSIBILITIESSQL 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

  • ID: #22391056
  • State: California Los angeles 90038 Los angeles USA
  • City: Los angeles
  • Salary: Market related
  • Job type: Contract
  • Showed: 2021-11-08
  • Deadline: 2022-01-07
  • Category: Et cetera