Database Administrator (DBA)

Employer
Acuity, Inc.
Location
Washington, DC
Posted
Sep 15, 2017
Closes
Sep 18, 2017
Hours
Full Time
Overview: Acuity, Inc. is a leading management and technology consulting firm that specializes in serving the federal government. Our innovative, collaborative and rewarding work environment has earned repeat honors from the Washington Business Journal's Best Places to Work and SmartCEO Corporate Culture awards.Acuity, Inc. seeks a dynamic, self-motivated SQL Server and Oracle DBA to support our federal government client. The qualified professional will serve as an SQL Server and Oracle DBA supporting multiple development, test, and production Oracle and SQL database environments in Windows 2008 and 2012 environments for multiple software development efforts. Install, upgrade and patch, design backup and recovery procedures, import/export database schemas, stored procedures, packages, triggers, and PL/SQL. Write complex queries and perform SQL tuning and database performance tuning. Maintain responsibility for maintaining ERDs and data dictionaries, troubleshooting database-related issues, and deploying database changes to development, test, and production environments. This position requires Secret clearance (must be clearable to TS). Responsibilities: The Lead Database Administrator's key duties and responsibilities include:Manage large enterprise databases, including Oracle and SQL. Support application infrastructure and Electronic Document Repository.Provide database administration (DBA) services, middle tier application server administration, and Oracle Cloud control monitoring to provide the database (DB) infrastructure required to support business applications. These services include customer inquiry and resolution; installation, operations and maintenance of Oracle resources to ensure adequate performance; data confidentiality, integrity and availability, as well as recoverability. Services include 24x7 on-call support.Maintain the physical DB, application server, and load balancer architectural design. Install, configure, and provide Operation and Maintenance of Oracle products such as the DB engine, application servers and OEM. Activities include the following: Install, configure, operate, and maintain the clustering of the databases, application servers and load balancers.Implement and maintain database security and audits. Generate and provide audit reports. Perform quality assurance and stress testing during non-business hours on systems in order to benchmark system/application or database performance. Stress testing must benchmark system response time, database response time, application response time, network throughput, network bandwidth, network latency, firewall throughput, maximum concurrent users, maximum concurrent requests, and other industry standard benchmarks.Perform database maintenance and recovery, including Backups, Exports, Image copies, Reorganizations, Database tool evaluation, Documentation.Perform data administration, including maintaining and enforcing standards for database design, naming, and accessProvide development assistance, including table generation and views. Problem determination and assistance with application database issuesProvide Disaster recovery support for databases Required Skills:Experience in managing SQL Server Cluster databases, particularly must be highly experienced in database backup and recovery, performance tuning, and high availability configuration.Must possess experience with SQL 2012 database administration.Must have experience in OracleExtensive experience in managing MS SQL databases.Must have experience with MS SQL 2012.Advanced knowledge in database security knowledge is requiredDesired Skills:SQL Server Clusters, Availability Groups (AGs)Oracle 12C single Instances #CB