Senior Database Engineer III

JOB TITLE: Senior Database Engineer III

POSITION INFORMATION: Full time

LOCATION: Remote/Telework; Onsite meetings in DC may be required 3-4 times/year

POSITION TIMING: Candidate must obtain a DHS Public Trust clearance prior to starting the position.

BENEFITS: Health, Dental and Vision, 401(k), Tuition Reimbursement, Flexible Spending Account (FSA), 11 Paid Federal Holidays, 3 weeks' Paid Time Off

ITC Federal, LLC is an information technology and consulting company focused on servicing the needs of the Federal Government. ITC's mission is to apply earned expertise in DevSecOps, Cloud Computing, Federal Financial Systems, App Dev, and Cyber Security to assist our clients in achieving their mission. ITC is located in Fairfax, VA and offersoutstanding compensation and benefits plan and a challenging and rewarding professional work environment.

Provides all activities related to the database administration. Able to communicate with management, technicians, and end-users to evaluate need prior to development of an automated solution. Prepares detailed reports which might include system requirements such as concurrent usage factors, data storage requirements, response rates, and discuss procedures for processing data through the use of database management systems (DBMS) including relational databases. Projects long-range requirements for database administration and design in conjunction with other managers in the information systems function. Designs, creates, and maintains databases in a client/server environment. Conducts quality control and auditing of databases in a client/server environment to ensure accurate and appropriate use of data. Advises users on access to various client/server databases. Designs, implements, and maintains complex databases with respect to access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods. Applies knowledge and experience with database technologies, development methodologies, and front-end (e.g., Informatica)/back-end programming languages (e.g., SQL). Performs database programming and supports systems design. Includes maintenance of database dictionaries, overall monitoring of standards and procedures, file design and storage, and integration of systems through database design. Evaluates database design tradeoffs, impacts on user expectations, performance levels, and space allocation requirements.

Provide support to include all database administration activities required to provide accessible, secure, scalable, and reliable databases to the customer. Primary responsibility: Managing Database Availability, Accessibility, Performance, Integrity, Enhancements, and ongoing Customer Delivery.

• Provide all activities related to database administration.
• Communicate with management, leadership, technicians, and end users effectively regarding database related issues.
• Perform 24x7 on-call support per the on-call support schedule.
• Support *NIX/Oracle, Unix Oracle databases and their structures.
• Maintain database system integrity and security
• Administration of storage, backup, restoration, and replication software
• Tracking of vendor maintenance and support agreements to ensure coverage.
• Provisioning of user-ids for all production and database servers.
• Participating in application design reviews.
• Initiate and support configuration management and change control processes and procedures
• Implementing and production support for database technology enhancements.
• Creating and maintain of standard operating procedures for production and DR database platforms as directed.
• Database Performance monitoring, and performance tuning.
• Complete required and recommended training/certifications for continued career development

• Oracle Certified Professional desired
• Strong work experience in cloud based database environments. Preferably AWS cloud, AWS Oracle/Postgres /mysql RDS
• Experience in Git hub/ terraform/ JIRA/Confluence
• Experience in Linux and UNIX database environments
• Experience in managing large databases in datacenter/cloud environments
• Experience in porting between different database platforms. ( ex from Oracle to Postgres)
• Hands-on experience in using cloud technologies like RDS console, read-replicas, cloud watch, monitoring metrics etc.
• Strong experience in problem solving and multi-tasking skills (technical and non-technical)
• Ability to write Python, Unix Shell scripts, lambda scripts for build and deployment automation
• Good knowledge of database monitoring tools (OEM), data analysis tools, ETL tools, BI tools
• Implement auto scaling, data distribution, cluster and query performance tuning methods, near real time data sync capabilities.

WORK ENVIRONMENT AND PHYSICAL DEMANDS: Candidate must be able to function in general office environment.

ITC Federal is an equal opportunity employer and will not discriminate against any application for employment on the basis of age, race, color, gender, national origin, religion, creed, disability, veteran status, marital status, sexual orientation, genetic information, military status, disability, or sex including pregnancy and childbirth or related medical condition or on any other basis prohibited by law.