Oracle / SQL Database Engineer (Secret Clearance)

Employer
Tech Filament
Location
Arlington, VA
Posted
Mar 20, 2017
Closes
Mar 22, 2017
Hours
Full Time
Job Description Our client in Crystal City, Virginia has a Full Time / Direct Hire job opening for an Oracle / SQL Database Engineer: The candidate must possess an Active Secret or Top Secret Security Clearance. Job Responsibilities: Start putting together SOPs for all customer enterprise SQL Server environments to include test/Dev and DR Document customer database environment Manage the customer SQL Server Test/Dev environment. Support adhoc requests from developers. Ensure all database servers are backed up in a way that meets the business's Recovery Point Objectives (RPO) Test backups to ensure we can meet the business' Recovery Time Objectives (RTO) Troubleshoot SQL Server service outages as they occur, including after-hours and weekends Configure SQL Server monitoring utilities to minimize false alarms As new systems are brought in-house, choose whether to use clustering, mirroring, or other technologies. Support any upcoming SQL Server projects Install and configure new SQL Servers Deploy database change scripts provided by third party vendors When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes. Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc) Each week, give developers a list of the top 10 most resource-intensive queries on the server and suggest ways to improve performance on each Design indexes for existing applications, choosing when to add or remove indexes When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes Conduct SQL Server lunch-and-learn sessions for application developers Ensure that new database code meets the customer standards for readability, reliability, and performance Required Qualifications: MYSQL or VMware or Oracle DBMS knowledge is a valuable bonus. Possess knowledge of SQL Server and its tools including the facets of successfully administering a wide range of simple to highly complex environments. Evaluate and install new software releases, patches and system upgrades. Knowledge and understanding of all aspects of database tuning: software configuration, memory usage, data access, data manipulation, SQL, and physical storage. Experience managing technology strategy / roadmap. Development and execution of database security policies, procedures and auditing-experience with database authentication methods, authorization methods, and data encryption techniques. Operating system and hardware platform knowledge preferred. Possess good communication skills, both oral and written. Must work well in a team environment as well as independently. Must exhibit good time management skills, independent decision making capability; focus on customer service. Ability to work with the other technical members of the team to administer and support the overall database and applications environment. The client offers a great benefits package including Health, Vision, Dental, 401K, Paid Vacation