Previous Job
Previous
Database Architect
Ref No.: 18-02581
Location: Cary, North Carolina
Database Architect/ DBA(Oracle/Azure)

Job Duties:
  • Design, Architect and Maintain Oracle, MS-SQL Databases in Azure Gov Cloud. General awareness of Cloud providers (AWS, Azure).
  • Adapt business requirements, developed by modeling/development staff and systems engineers, and develop the data, database specifications, and table and element attributes for an application, including stored/remote procedure calls.
  • Code moderately complex to complex programs and derive logical processes on technical platforms. Provide expertise in devising, negotiating and defending the tables and fields provided in the database.
  • Determine how tables relate to each other and how fields interact within the tables for a relational model. Participate in quality assurance and develop test application code in client server environment.
  • Install database management systems.
  • Monitor file system space database allocation. Verify efficient use of disk storage; reclaim dead space; optimize space allocation and avoid out of space conditions.
  • Refresh data from one environment to another at the request of the application development staff; execute necessary tasks to accomplish this, including export, drop, create, and import prescheduled time to minimize impact; provide application development staff optimal development environment with current data.
  • Closely monitor performance; identify problems and implement solutions; ensure database is running at optimum speed and efficiency.
  • Verify implementation of correct backup strategy; develop recovery procedures; support recovery from loss of data caused by user or system error.
  • During times of emergencies, outages and project planned work; employees are expected to be on call and available until the event is addressed.
  • During system conversions, extra effort may be required in order to ensure the roll out of the system is successful. Perform other job-related duties as assigned.

Required Skills:
  • Expected to be fully versed in logical data modeling and how to translate it into physical database design.
  • Expected to understand and apply system management, performance timing and troubleshooting techniques.
  • Use skills as a seasoned, experienced professional with a full understanding of industry practices and company policies and procedures; resolve a wide range of issues in imaginative as well as practical ways.
  • Has knowledge and experience in database technologies - Oracle 11g, Oracle 12c, MS-SQL, Vertica, Vertica EON.
  • Vertica - basic understanding required.
  • Formal software, information and system engineering skills are acquired.
  • Work with others to resolve problems, clarify or interpret complex information/policies, and provide initial screening/negotiations without approval authority.
  • This job is the fully qualified, career-oriented, journey-level position.
  • Installation & Configuration of databases, Security and Hardening of Oracle/MS-SQL databases, Backup, Recovery, Data Guard, Active Data Guard, OEM 13c Monitoring, Monitoriing Templates, OEM Reporting/Dashboards, Performance Tuning, SQL Tuning, Capacity Planning, Automation, Shell Scripts, Patches/Upgrades, Documentation & Standards, Review FedRamp controls and translate to technical requirements, Maintain documentation, wiki pages, Experience with Azure, AWS Cloud preferred but not required. Vertica experience preferred.
  • Bachelor's degree or global equivalent.

Desired skills:
  • Some experience with Vertica EON preferred.
  • Basic Vertica knowledge required.
  • Document and communicate database design.
  • Golden Gate experience preferred but not required.