What are the responsibilities and job description for the DTS Database Engineer position at freedomconsulting?
Freedom Technology Solutions Group is seeking a DTS Database Engineer. The day-to-day tasking for this position includes:
• Perform Database Administration (DBA) activities on a daily basis such as monitoring storage, database performance, and RMAN back up verification
• Ensure standby DataGuard databases are functioning properly with minimal lag time
• Develop strategies to migrate data between environments
• Identify and resolve database performance issues
• Support the database design, development, implementation, information storage and retrieval, data flow and analysis activities
• Support the analysis and evaluation of system improvements, optimization, development and/or maintenance efforts.
• Translate a set of requirements and data into a usable database schemas
• Create and update data models using PowerDesigner
• Assist in developing database structures that fit into the overall architecture of the system under development.
• Develop a database structure that fits into the overall architecture of the system under development and has to make trades among data volumes, number of users, logical and physical distribution, response times, retention rules, security and domain controls.
• Direct the development of complex systems using queries, tables, Open -Database Connectivity and database storage and retrieval.
Required Qualifications:
- TS/SCI with Polygraph
- Bachelor’s degree in System Engineering, Computer Science, Information Systems, Engineering Science, Engineering Management, or related discipline from an accredited college or university plus 12 years of relevant experience or a Master’s degree plus 10 years of relevant experience. An Associate’s degree plus 14 years of relevant experience or high school diploma/GED plus 16 years of experience may be considered for individuals with in-depth experience that is clearly related to the position. A relevant certification may count as one year of experience.
- Oracle, Linux, SQL, scripting. *1 week of on-call support every 3-5 weeks required after ramp-up.
Desired:
- Oracle RAC, Oracle Data Guard, RMAN backups, Oracle Enterprise Monitoring (OEM)
Experience with Jira and Confluence
Experience with Relational database design tools such as Power Designer
The estimated salary range for this position is between $160,000.00 and $200,000.00 (annualized USD). This range reflects the typical pay for the role and is one part of the company's comprehensive compensation package. Actual salaries are influenced by several factors, such as location, the individual’s education, skills, experience, and competencies, as well as contract affordability and organizational needs.
Salary : $160,000 - $200,000
