SQL Server DBA with AWS
- InfoChain Technologies Inc.
5 Hours Ago
NA
NA
Arlington-VA
5-7 Years
Required Skills: AWS Services, CloudWatch, IAM, MS SQL Server 2017/2019/2022, SQL database replication via script, Python scripting, PowerShell, MS SQL, Aurora/RDS PostgreSQL, MySQL, Azure DevOps, Terraform, GIthub, TFS/Visual Studio database, CI/CD platforms, C#, Kibana, DataDog
Job Description
SQL Server DBA with AWS
Fulltime with end client
Location: Arlington, VA(Hybrid)
Exp: 5-7 Years
Demonstrate extensive knowledge of all aspects of Microsoft SQL Server, including administration, replication, backup/restore procedures and related components such as Reporting Services, Analysis Services, and Integration Services.
Implement and Maintain Automated Processes using TSQL/PowerShell/Python scripts
Understand AWS-based architecture and closely work with DevOps, SecOps and develop scripts to deploy and maintain the environment.
Install, configure, monitor, and maintain databases in the production, development, and quality assurance environments.
Process database change requests, including the creation and modification of databases, tables, views, stored procedures, triggers, jobs, etc. in accordance with change control policies.
Work outside of normal business hours as required to complete projects, work on deployments, and resolving system outages.
To be placed on on-call rotation for a week every 3 months and respond to system alerts
Requirements:
AWS Experience - Knowledge of various AWS services (EC2, RDS, S3, EBS, Lambda), CloudWatch, IAM.
3+ years of experience with Microsoft SQL Server 2017 / 2019/ 2022 supporting high-traffic websites.
Experience with the implementation and support of database replication.
Experience working with very large databases, upgrades, troubleshooting performance, etc.
Experience with the implementation and support of SQL database replication via script
Experience with SQL Server High Availability Architecture (AlwaysOn) and troubleshooting.
Understanding of Windows Server configuration and management, specifically as it relates to MS SQL Server installations and mission-critical systems.
Excellent understanding of coding with Microsoft T-SQL and stored procedures.
Desire to learn and administrate new cloud technologies in order to support a variety of database engines such as AWS Database Engines (RDS, Snowflake, Databricks)
Experience with adhering to and implementing best practices within an enterprise environment that includes using source control for all database-related artifacts (including jobs, SSIS packages, and replication configuration) and following a change request/notification policy.
Experience with either Python scripting and/or PowerShell is required
Understands and is able to properly implement backup and disaster recovery procedures.
Excellent work ethic and willingness to put in significant extra time with large team members are required.
Bachelor's degree from an accredited, not-for-profit University or College.
A track record of commitment to prior employers
Nice to have (Big Plus):
Familiarity with Relational Database Management experience such as MS SQL, Aurora / RDS PostgreSQL, MySQL
Familiarity with Azure DevOps / Terraform / GitHub is a big plus
Experience with TFS/Visual Studio Database Projects, Azure DevOps, Terraform, CloudFormation, or any other CI/CD platforms
Any other programming skills are valuable, such as C#
Knowledge of monitoring tools such as Kibana, CloudWatch, DataDog, or any other tools, etc.
