Database Administrator, Specialist
HybridCharlotte, North Carolina, United States or Wayne, Pennsylvania, United States
Charlotte, North Carolina, United States or Wayne, Pennsylvania, United StatesHybridFull TimeBachelors DegreeFINANCEEnterprise
Full TimeBachelors DegreeEnterpriseFINANCE
Job Summary
Manage and maintain backup, recovery, security, and performance of enterprise database technology across Oracle, SQL Server, and AWS platforms. Create and maintain recovery jobs, resolve database issues to determine root cause, and perform administration, installation, upgrades, and patching. Provide on-call support on a rotational basis and assist developers with technology recommendations and testing. Review application designs for compliance and provide technical input for large-scale projects.
Required Qualifications
- Undergraduate degree in a related field or the equivalent combination or training and experience
- Minimum of five years database administrator experience with Oracle, SQL Server or AWS (Postgres, DynamoDB)
- Certification in Oracle, SQL Server, or AWS
- Excellent written and oral communication skills, including interviewing and presentation skills
- Strong relationship management, analytical, problem solving and organizational skills
- Broad knowledge of the financial services industry
- Ability to effectively multi-task
- Flexibility, strong decision-making skills and effective time management skills
- Proven ability to work with attention to detail under tight time constraints
- Working knowledge and experience with some or all the following: MS Windows and/or Linux (Redhat) based operating systems
- Virtualization – VMware
- Distributed Computing Hardware Technologies
- Network Technologies – SDN, DNS, Ethernet Fabrics, Firewalls, Load Balancers, WAN, WiFi, etc.
- Directory Services – Active Directory/LDAP
- Backup and disaster recovery testing
- Job scheduling (Control-M)
- ITIL (Incident/Problem Management, CMDB) (ServiceNow)
- DBA best practices and concepts: database backup & recovery, database performance tuning, database monitoring, and maintenance
- Hands on experience of Oracle, SQL Server and AWS (Postgres, DynamoDB) database technologies
- Troubleshoot complex systems to identify bottlenecks (SQL, IO, hardware, query related, etc.) and resolve database related issues
- Ability to support multiple releases (e.g., Oracle 12c/18c/19c, Microsoft SQL Server 2016/2019, etc)
- Designing databases and data modeling concepts
- Automation and scripting skills; PowerShell, Shell Scripting, PL/SQL, T-SQL, etc.
- Working knowledge of Cloud Providers & Solutions / AWS
- Great communication and documentation skills that leads to internal problem resolutions documents, lessons learned, how to, and knowledge transfer
- Strong skills with troubleshooting, researching and resolving blocking/deadlocking, connectivity issues, data corruption, security issues etc
- DBA in an operational role supporting Oracle (10-19) on Linux (RedHat) platform
- Strong skills using Bash/Korn shell scripting & PL/SQL for automation of database administration tasks and notifications
- Experience with high availability using Oracle RAC
- Disaster Recovery using Oracle Data Guard
- Working experience of RMAN for backups and recovery using a catalog
- Working experience using Oracle Enterprise Management (OEM) for monitoring & alerting
- Working experience of Linux (RedHat)
- Working experience with basic performance tuning
- Working experience of Oracle tools, (Toad, SQL Developer, OEM, OID, etc.)
- DBA in an operational role supporting MS SQL Server (2012-2019) on MS Windows
- Strong skills using PowerShell scripting & T-SQL for automation of database administration tasks and notifications
- Experience with Disaster Recovery/High Availability using Always ON Availability Groups, Replication, and Mirroring
- Knowledge of SQL Server backup/restore models
- Experience using MS SCOM for monitoring & alerting
- Knowledgeable of the MS Windows Server environment
- Experience with basic Performance Tuning
- Knowledge of SQL Server tools, (SSMS, SCOM, Extended Events, SQL Profiler, Query Store, Brent Ozar procedures, etc.)
- DBA in an operational role supporting AWS Postgres and DynamoDB in production environment
- Creation and removal of reader/writer instances
- Strong skills using AWS tools for automation of database administration tasks and notifications
- Experience with Disaster Recovery/High Availability using replication and mirroring
- Knowledge of AWS backup/restore models
- Experience using AWS Cloudwatch for monitoring & alerting
- Experience with basic performance tuning
- Welcome challenges with enthusiasm, high-energy and a sense of urgency
- Drive outcomes in an ambiguous environment through the people, process and technology
- Independently keep up with technology trends and apply that to their day-to-day work
- Manage multiple priorities and work effectively to provide thought leadership to IT management
- Must be able to perform on-call support on a rotational basis
- Must be able to provide support during normal business hours to developer requests on a rotational basis
- Must be able to review application designs for compliance with production acceptance requirements
- Must be able to provide key technical input and expertise in large scale projects
- Must be able to assist with testing and evaluating IT vendor products
- Must be able to recommend database technology features/functions to application developers
- Must be able to ensure backup, recovery, security, availability, maintenance and performance of enterprise database technology
- Must be able to create and maintain backup and recovery jobs
- Must be able to resolve database issues and help to determine root cause
- Must be able to perform administration, installation, upgrade, configuration, and patch management of all enterprise database technology
- Must be able to ensure operational availability/recoverability of all enterprise database platforms
- Must be able to perform administration/maintenance, upgrades/patching, performance tuning and completion of database requests from internal customers
- Must be able to work with application developers, fellow DBA's, and IT leadership to improve the efficiency, resiliency, production stability, automation, and reliability of Vanguard's database infrastructure
- Must be able to work with the Database Operations team supporting Oracle, Microsoft SQL Server and AWS database technologies (Postgres, DynamoDB, etc.)
Desired Qualifications
- Certification in Oracle, SQL Server, or AWS, preferred but not required
- Working knowledge of Cloud Providers & Solutions / AWS preferred
- Oracle Skill set should include: DBA in an operational role supporting Oracle (10-19) on Linux (RedHat) platform
- Strong skills using Bash/Korn shell scripting & PL/SQL for automation of database administration tasks and notifications
- Experience with high availability using Oracle RAC
- Disaster Recovery using Oracle Data Guard
- Working experience of RMAN for backups and recovery using a catalog
- Working experience using Oracle Enterprise Management (OEM) for monitoring & alerting
- Working experience of Linux (RedHat)
- Working experience with basic performance tuning
- Working experience of Oracle tools, (Toad, SQL Developer, OEM, OID, etc.)
- DBA in an operational role supporting MS SQL Server (2012-2019) on MS Windows
- Strong skills using PowerShell scripting & T-SQL for automation of database administration tasks and notifications
- Experience with Disaster Recovery/High Availability using Always ON Availability Groups, Replication, and Mirroring
- Knowledge of SQL Server backup/restore models
- Experience using MS SCOM for monitoring & alerting
- Knowledgeable of the MS Windows Server environment
- Experience with basic Performance Tuning
- Knowledge of SQL Server tools, (SSMS, SCOM, Extended Events, SQL Profiler, Query Store, Brent Ozar procedures, etc.)
- DBA in an operational role supporting AWS Postgres and DynamoDB in production environment
- Creation and removal of reader/writer instances
- Strong skills using AWS tools for automation of database administration tasks and notifications
- Experience with Disaster Recovery/High Availability using replication and mirroring
- Knowledge of AWS backup/restore models
- Experience using AWS Cloudwatch for monitoring & alerting
- Experience with basic performance tuning
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.