People Force Consulting Inc
Job Title
SQL Server DBA
Location Phoenix, AZ (Onsite)
Duration Long Term
Local Requirement Need Locals Only F2F is Mandatory
Must Have Skills
Extensive knowledge in SQL Server Technologies with at least 4 years of experience
Strong experience with MS SQL Server 2008/2008 R2/2012/2014/2016/2017/2019, over 3 years of experience with SQL 2016 & SQL 2017
Experience in performance tuning, blocking/locking/deadlocks, mirroring, always on, memory pressure, CPU, I/O latency, and capacity management
Experience troubleshooting database issues in production and non-production environments using diagnostic & compliance management tools
Experience with High Availability and Disaster Recovery solutions using SQL Server Always On Technology
Experience in Azure Cloud Migration both PaaS & IaaS solutions
Experience with database backup and recovery, monitoring solutions, automating DBA tasks, database tuning and capacity planning
Experience managing databases ranging from 10GB to 5TB, implementing and maintaining standard SQL maintenance jobs, HADR solutions (Always On, Mirroring, Replication)
Responsibilities
Design, configure, implement, and administer all databases for the respective parties involved
Identify and resolve all issues related to database systems to ensure systems are online and without service interruption
Provide On-Call DBA support during weekday off-peak business hours and weekends as needed
Analyze and report the performance of database operations against key performance metrics
Meet performance standards in accordance to service level agreements set by the company
Manage databases at the infrastructure level, including patches, upgrades, and participation in DR exercises
Continuously monitor database systems and resolve any issues that arise from an infrastructure perspective
Support high availability and disaster recovery solutions such as Always On, Mirroring, and Replication
#J-18808-Ljbffr
Location Phoenix, AZ (Onsite)
Duration Long Term
Local Requirement Need Locals Only F2F is Mandatory
Must Have Skills
Extensive knowledge in SQL Server Technologies with at least 4 years of experience
Strong experience with MS SQL Server 2008/2008 R2/2012/2014/2016/2017/2019, over 3 years of experience with SQL 2016 & SQL 2017
Experience in performance tuning, blocking/locking/deadlocks, mirroring, always on, memory pressure, CPU, I/O latency, and capacity management
Experience troubleshooting database issues in production and non-production environments using diagnostic & compliance management tools
Experience with High Availability and Disaster Recovery solutions using SQL Server Always On Technology
Experience in Azure Cloud Migration both PaaS & IaaS solutions
Experience with database backup and recovery, monitoring solutions, automating DBA tasks, database tuning and capacity planning
Experience managing databases ranging from 10GB to 5TB, implementing and maintaining standard SQL maintenance jobs, HADR solutions (Always On, Mirroring, Replication)
Responsibilities
Design, configure, implement, and administer all databases for the respective parties involved
Identify and resolve all issues related to database systems to ensure systems are online and without service interruption
Provide On-Call DBA support during weekday off-peak business hours and weekends as needed
Analyze and report the performance of database operations against key performance metrics
Meet performance standards in accordance to service level agreements set by the company
Manage databases at the infrastructure level, including patches, upgrades, and participation in DR exercises
Continuously monitor database systems and resolve any issues that arise from an infrastructure perspective
Support high availability and disaster recovery solutions such as Always On, Mirroring, and Replication
#J-18808-Ljbffr