Job Details

Home

SQL DBA with Azure,Powershell Client : TCS Rate $55 at Remote, Remote, USA

Email: [email protected]

SQL DBA with Azure,Powershell

Chicago, IL

SQL
Server DBA Infrastructure Support (AlwaysON, Password rotations of SQL
server)Backup and recoveryPerformance tuning and troubleshootingWindows
Server & ClusteringPowerShell ScriptingGood to have Chef/Chocolatey
packaging experience.Exposure to cloud services (GCP, AWS, Microsoft
Azure)Knowledge on the GitOps and CI/CD

Provide
support for a large footprint of Microsoft SQL Server instances including
AlwaysOn availability groups and failover clustering
configurations.Support SQL Server 2016/2019 on Physical and VMware
Hypervisor.Responsible for database backup and recovery methods, database
access security and integrity, physical data storage design and database
storage administration.

Involved
in disaster recovery planning. Participate in several Business Continuity
DR tests per year in coordination with the Business Continuity team.
Document DR processes.Understand SOC1/SOC2/Internal Audit/Yearly Audit
requirements for compliance reporting.Participate in 24x7 follow the sun
on-call rotation, shared between 3 regions (US, Ireland and India)Provide
Production support including Saturday Deployment support.

Support
DB and OS Patching initiatives on a monthly/quarterly basis. Remediate
MSSQL vulnerabilities identified by the Vulnerability Mitigation
Team.Participate in continuous process improvement, focussing on reduction
of manual tasks via automation.

Implements
and maintains configuration of each database instance to baseline standard
access controls.

Make
recommendations for database system architecture per Microsoft SQL Server
best practice.

Deploy
and manage updates to scheduled jobs within UC4 Scheduler and SQL Server
Agent.P

roactively
monitor SQL Server maintenance tasks, troubleshoot failed processes, and
address issues promptly.

Troubleshoot
and investigate application performance issues as they relate to the
database.

Provide
appropriate guidance and solutions.Tune T-SQL queries and provide guidance
to developers on best practice.

Manage
and coordinate database migrations and database software and hardware
upgrades.

Create
documentation and training for routine database administration activities,
as well as train server operations employees on them

Support
standard DBA security processes such as password rotation, TDE, SSL and DB
Auditing

Attend
Standup/Planning/Issues review/Change Control and Customer facing meetings
as representative of the team.

Experience
with Onprem to Cloud DB Migration on Compute Engine and Managed Services.

--

Keywords: continuous integration continuous deployment database information technology Illinois

[email protected]
View all

Thu Jan 18 20:43:00 UTC 2024

To remove this job post send "job_kill 1026810" as subject from [email protected] to [email protected]. Do not write anything extra in the subject line as this is a automatic system which will not work otherwise.

Your reply to [email protected] -

To

Subject
Message -

gurnavstaffing@gmail.com wrote:
SQL DBA with Azure,Powershell

Chicago, IL

SQL
     Server DBA Infrastructure Support (AlwaysON, Password rotations of SQL
     server)Backup and recoveryPerformance tuning and troubleshootingWindows
     Server & ClusteringPowerShell ScriptingGood to have Chef/Chocolatey
     packaging experience.Exposure to cloud services (GCP, AWS, Microsoft
     Azure)Knowledge on the GitOps and CI/CD

Provide
     support for a large footprint of Microsoft SQL Server instances including
     AlwaysOn availability groups and failover clustering
     configurations.Support SQL Server 2016/2019 on Physical and VMware
     Hypervisor.Responsible for database backup and recovery methods, database
     access security and integrity, physical data storage design and database
     storage administration.

Involved
     in disaster recovery planning. Participate in several Business Continuity
     DR tests per year in coordination with the Business Continuity team.
     Document DR processes.Understand SOC1/SOC2/Internal Audit/Yearly Audit
     requirements for compliance reporting.Participate in 24x7 follow the sun
     on-call rotation, shared between 3 regions (US, Ireland and India)Provide
     Production support including Saturday Deployment support.

Support
     DB and OS Patching initiatives on a monthly/quarterly basis. Remediate
     MSSQL vulnerabilities identified by the Vulnerability Mitigation
     Team.Participate in continuous process improvement, focussing on reduction
     of manual tasks via automation.

Implements
     and maintains configuration of each database instance to baseline standard
     access controls.

Make
     recommendations for database system architecture per Microsoft SQL Server
     best practice.

Deploy
     and manage updates to scheduled jobs within UC4 Scheduler and SQL Server
     Agent.P

roactively
     monitor SQL Server maintenance tasks, troubleshoot failed processes, and
     address issues promptly.

Troubleshoot
     and investigate application performance issues as they relate to the
     database.

Provide
     appropriate guidance and solutions.Tune T-SQL queries and provide guidance
     to developers on best practice.

Manage
     and coordinate database migrations and database software and hardware
     upgrades.

Create
     documentation and training for routine database administration activities,
     as well as train server operations employees on them

Support
     standard DBA security processes such as password rotation, TDE, SSL and DB
     Auditing

Attend
     Standup/Planning/Issues review/Change Control and Customer facing meetings
     as representative of the team.

Experience
     with Onprem to Cloud DB Migration on Compute Engine and Managed Services.

Keywords: continuous integration continuous deployment database information technology Illinois

Your email id:

Captcha Image:

Captcha Code:

Pages not loading, taking too much time to load, server timeout or unavailable, or any other issues please contact admin at [email protected]
Time Taken: 0

Location: ,