Oracle SQL DBA at Atlantic Partners Corporation

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 team’s 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