Sr. Database Administrator

Qualifications: Windows • Working knowledge of Windows troubleshooting, including performance, memory management, I/O tuning, configuration, security, networking, clusters, and troubleshooting. Scripting/Automation • Good scripting ability and good working knowledge of PowerShell • Proven track record of automating tasks • Familiar with SQL Server Integration Services Nice to have: AWS RDS • Hands-on experience or working knowledge of database technology in AWS • Experience in provisioning and administrating RDS SQL Server instances • Familiarity with AWS Services (EC2, EBS, S3, RDS, DMS, Config, Secrets Manager etc.) Responsibilities: • The Database Administrator is responsible for data analysis and database management. • Database Administrators typically are involved in maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning. • Database Administrators are also responsible for understanding, configuring, and managing database administration tools. • Provides database support for business applications and schedules back up jobs for user databases. • Provides access control (password resets /account creation/deletion) and checks IP compliance (violation report review, compliance updates and compliance set ups). • Performs data purging and data replication activities. • Research on connectivity issues and recurring errors in Application database. • Responds to database alerts and takes appropriate actions. • Provides escalation Level 1 and 2 Technical 24x7 support. • Performs database creations. • Performs performance tuning and troubleshooting for database. • Performs application database maintenance and provides technical assistance to users. • Manages database account access and database object changes. • Ensures that monitoring and alerts are properly in place to meet monitoring requirements. • Performs application database and OS scripting. • Reviews Information Protection compliance reports and notifications for individual databases and internal processes (including compliance updates and compliance set ups). • Performs data purging and data replication activities • Performs database recovery from logs, hot & cold backups, Export/Imports and Disaster Recovery. • Performs database creation decommissioning and database updates/migrations to a higher/lower version or cross platform migrations. Also involved in database, schema, and object refresh activities. • Monitors and reports existing database Instance, Database, Server activities for CPU, Memory, and Cach, logs performance, and recommends effective resource utilization/emergency recovery procedures • Provides Escalation Level 2 Technical 24x7 support. • Performs Business Continuity/Disaster Recovery activities during Business Continuity Plan events. • Plans, schedules, and implements operating system software installs and patches (including 3rd party tools) using change management and release management processes. • Implements database security and auditing features and periodic reviews. Conducts root cause analysis for repeated incidents. • Performs heterogeneous database interface 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 a higher/lower version or cross platform migrations. Also, involved in database, schema and object refresh activities. • Develops capacity planning processes that include monitoring of existing database Instance, Database, Server activities for CPU, Memory, Cache, Logs performance and recommends effective utilization of resources and emergency recovery procedures. • Conducts team training and responsible for resource management. • Provides escalation Level 2 and 3 Technical 24x7 support. • Researches new technologies to address operations reliability and compliance. • Implement's and performs configuration management of database cluster and replications.