Atlantic Partners
Oracle SQL DBA
Atlantic Partners, Charlotte, North Carolina, United States, 28245
Our client is seeking a motivated, career and customer-oriented Sr. Oracle Database Administrator (SQL) to join our team.
Responsibilities:
Provide the daily leadership, scheduling and assurance that all routine and ad hoc project management/scheduling, system administration and IT infrastructure processes are handled to satisfaction for the Database Administrators
Assists in coordination of all maintenance activities that may impact SQL Server or Oracle
Supply other managerial functions to team and with guidance from Operations Manager, such as performance reviews and metrics, coaching/consulting, personnel task assignment, in- and out- of cycle reporting and status of teams activities and/or issues. Support and assure adherence to all corporate and client site policies.
Responsible for the security and management of Database systems in non-production and production environments across 2 physical locations
Solve complex integration and technical problems in a highly available, dynamic fast-paced enterprise environment
Act as a Senior Database Administrator directing team members to ensure all requirements are delivered in an efficient, highly productive manner on over 100 virtual and physical nodes; over 200 instances and countless Oracle and SQL Server databases
Provide technical support for the day-to-day SQL Server activities of the organization
Provide technical Support for chartered Projects, e.g. Security Remediation, Disaster Recovery
Recommend and Implement database changes to improve performance and security
Plan, coordinate, and implement security measures to safeguard databases
Research and create documentation for FISMA/STIG findings and waiver requests
Measure database performance, capacity and troubleshoot complex database issues
Configure and monitor interfaces with other systems
Configure and maintain system databases, user databases, server instances, schema, tables, views, functions, triggers and indexes
Configure and manage system and database user IDs and group permissions, database backups and recoveries
Configure, monitor, and troubleshoot peer-to-peer database replication and AlwaysOn Availability
Assist Windows System Administrators with basic Windows Failover Cluster configuration and management
Assist Windows System Administrators with basic Windows Disk Management
Create and update Configuration Item documentation, Standard Operating Procedures and Installation/Upgrade Guides
Work with other DBAs, Systems Administrators, Network Administrators, Storage Administrators, Enterprise Security Team, Backup Administrators and application developers to resolve various system issues
Qualifications: Enterprise level SQL Server administration of replicated, highly available enterprise environment Security focused mindset experienced with large scale enterprise deployments of applications, patches and security updates across a diverse multi customer environment Knowledge of basic Windows, Linux, Storage, Network and Backup concepts Efficient at T-SQL and Batch scripting Experience installing, configuring, securing, and optimizing SQL Server Databases in a clustered, physical and virtual environment Experience with High Availability, Always On and Data Replication technologies as related to SQL Servers Experience writing and debugging scripts in PowerShell Ability to create and maintain documentation reflecting the current operational environment Excellent communicator, both verbally and written, with an ability to understand and discuss highly technical subjects to multiple levels of internal and external leadership. Requires 24x7 on call support on a rotating basis Microsoft's MTA, MCSA, or MCSE, or replacement with SQL Server focused certification is a requirement. Education: A Bachelor's degree or equivalent in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline with 7 or more years related professional experience. (Education can be substituted for 10 years of experience). Preferred Qualifications: Familiar with Spotlight, SolarWinds or some other type of SQL monitoring Familiar with SQL database clustering in Windows environment Familiar with SAN storage for SQL and Oracle databases Familiar with Oracle Database configurations and management tools Familiar with VMWare concepts ITIL Certification
Qualifications: Enterprise level SQL Server administration of replicated, highly available enterprise environment Security focused mindset experienced with large scale enterprise deployments of applications, patches and security updates across a diverse multi customer environment Knowledge of basic Windows, Linux, Storage, Network and Backup concepts Efficient at T-SQL and Batch scripting Experience installing, configuring, securing, and optimizing SQL Server Databases in a clustered, physical and virtual environment Experience with High Availability, Always On and Data Replication technologies as related to SQL Servers Experience writing and debugging scripts in PowerShell Ability to create and maintain documentation reflecting the current operational environment Excellent communicator, both verbally and written, with an ability to understand and discuss highly technical subjects to multiple levels of internal and external leadership. Requires 24x7 on call support on a rotating basis Microsoft's MTA, MCSA, or MCSE, or replacement with SQL Server focused certification is a requirement. Education: A Bachelor's degree or equivalent in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline with 7 or more years related professional experience. (Education can be substituted for 10 years of experience). Preferred Qualifications: Familiar with Spotlight, SolarWinds or some other type of SQL monitoring Familiar with SQL database clustering in Windows environment Familiar with SAN storage for SQL and Oracle databases Familiar with Oracle Database configurations and management tools Familiar with VMWare concepts ITIL Certification