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!
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
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