Title: SQL Server DBA
Onsite in Atlanta, GA. Hybrid 3 days onsite, 2 daysremote. Following week 2 days onsite, 3 days remote. Etc
Initial Duration: 12 months
Skype
JD
Required skills: SQL Server and AWS
Qualifications:
This position is for a MICROSOFT SQLSERVER DBA.
Responsibilities:
The Database Administrator isresponsible for data analysis and database management.
Database Administratorstypically are involved in maintenance, enhancement, designing of datadictionaries, physical and logical database models, and performance tuning.
DatabaseAdministrators are also responsible for understanding, configuring, andmanaging database administration tools.
'-Provides database support forbusiness applications and schedules back up jobs for user databases.
-Providesaccess control (password resets /account creation/deletion) and checks IPcompliance (violation report review, compliance updates and compliance setups).
-Performs data purging and data replication activities. -Researches onconnectivity issues and recurring errors in Application database. -Responds todatabase alerts and takes appropriate actions.
-Provides escalation Level 1 and2 Technical 24x7 support. -Performs database creations. '-Performs performancetuning and troubleshooting for database.
-Performs application database maintenanceand provides technical assistance to users. -Manages database account accessand database object changes.
-Ensures that monitoring and alerts are properly inplace to meet monitoring requirements. -Performs application database and OSscripting.
-Reviews Information Protection compliance reports and notificationsfor individual databases and internal processes (including compliance updatesand compliance set ups).
-Performs data purging and data replication activities
-Performs database recovery fromlogs, hot & cold backups, Export/Imports and Disaster Recovery. -Performsdatabase creation decommissioning and database updates/migrations to ahigher/lower version or cross platform migrations.
Also involved in database,schema, and object refresh activities. -Monitors and reports existing databaseInstance, Database, Server activities for CPU, Memory, and Cach, logsperformance, and recommends effective resource utilization/emergency recoveryprocedures
-Provides Escalation Level 2Technical 24x7 support. -Performs Business Continuity/Disaster Recoveryactivities during Business Continuity Plan events.
-Plans, schedules, andimplements operating system software installs and patches (including 3rd partytools) using change management and release management processes.
-Implementsdatabase security and auditing features and periodic reviews. Conducts rootcause analysis for repeated incidents.
-Performs heterogeneous databaseinterface deployment and support for various data interfaces with applications,Middleware interface and functionality deployment with database architecture.
-Plans and develops processes for database updates and migrations to ahigher/lower version or cross platform migrations. Also, involved in database,schema and object refresh activities.
-Develops capacity planning processesthat include monitoring of existing database Instance, Database, Serveractivities for CPU, Memory, Cache, Logs performance and recommends effectiveutilization of resources and emergency recovery procedures.
-Conducts teamtraining and responsible for resource management.
-Provides escalation Level 2and 3 Technical 24x7 support. -Provides Business Continuity Planning/DisasterRecovery support.
-Researches new technologies to address operationsreliability and compliance. -implement's and performs configuration managementof database cluster and replications.