Vacancy expired!

Position: SQL DBALocation: Oklahoma City, OKDuration: 12 months

Day 1 onsite

• Installation and Configuration of 2005/2008/2008R2/2012/2014/2016/2017 on new 32-bit and x64-bit Operating System across prod/Dev/UAT environments. Implementation of Best practices/hardening as per Microsoft and organization standards. Experience in installation and maintenance of SQL Server Clusters and Always On Clusters• Design database Backup and Restoration Strategy. Configure SQL server maintenance plan, SQL Agent job, 3rd party schedulers etc.• Perform database and application performance/tuning including exposure on query level tuning and System level tuning. Usage of SQL Profiler, Performance Monitor and DBCC and DMV Commands for RCA.• Configure and maintain HA-DR solutions like Logshipping/Mirroring/AlwaysOn, Exposure to replication : Snapshot/Transactional/Merge• Migration/Upgradation of SQL Server from older versions to higher ones and applying service packs and patches• Patching/Service pack Upgrades/VTMs/Hotfixes, periodic updates etc.• Strong knowledge of DB security fundamentals. Perform Security level activities including creating logins/users, assigning roles-permissions etc. - Deep understanding of different Database Security Standards and expertise in implementing and configuring its solutions• Should be able to Understand the customer requirement on data management and help them to meet the PII compliances• 1Experience with Database Auditing using DB packages and procedures and raising flags whenever necessary.- Experience with Data Security Monitoring tools• Analyze existing configurations and recommend if any changes are needed to ensure that the databases are complaint to the Security policies• Proficient with SQL Management Studio, Enterprise Manager, Query Analyzer, rescheduling jobs with SQL Server• Creating DB Maintenance plans, rebuild/reorganize indexes & performing integrity checks.• Highly proficient in database Backup, Restore, Recovery, Linked servers, and Database Maintenance Plans. Experience with High Availability and Disaster Recovery like Replication, Log shipping, Mirroring and Clustering.• Proficient in implementing different types of Replication models like Snapshot, Transactional and Merge.• Experience in Implementing Always On in SQL Server 2012, 2014, 2016 and 2017.• Experience in Implementing Database Mirroring in SQL server 2005/2008/2008R2.• Involved in Installing, Configuring and Maintaining of Cluster in SQL Server 2008R2 and SQL Server 2012 in Active/Passive.• Auditing database configuration and security configurations.• Actively involved in System Performance by tuning SQL queries and stored procedures by using SQL Profiler, Database Engine Tuning Advisor, Windows performance monitor, DMVs, Resource Governor, Data collection Reports, crystal reports, DBCC and Custom Script, Built-in performance Report and Activity Monitor.• Experience with Database Backup and Restore.• Good to Have – Automation Scripting through PowerShell /Shell Scripting /Python etc.

  • ID: #43741215
  • State: Oklahoma Oklahoma city 73101 Oklahoma city USA
  • City: Oklahoma city
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2022-07-01
  • Deadline: 2022-08-26
  • Category: Et cetera