Previous Job
Previous
Principal DBA - 2
Ref No.: 18-08463
Location: Cary, North Carolina

Job Title:Principal DBA
Job Location:Cary,NC

Job Description:
  • Design, Architect and Maintain Oracle, MS-SQL Databases in Azure Gov Cloud. General awareness of Cloud providers (AWS, Azure). Some experience with Vertica EON preferred. Basic Vertica knowledge required.
  • Document and communicate database design. 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.
Responsibilities:
  • 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 experience preferred but not required. 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.
  • Golden Gate experience preferred but not required.

** 10 time INC 500/5000, 10 time BBJ "Pacesetter ", 5 time SIA-fastest growing**
___________________________________________________________
Sakshi Gupta | TalentBurst, Inc.
Boston | San Francisco | Miami | Milwaukee | Toronto | New Delhi | Bangalore
Work: (508) 848-0307| Email: sakshi.gupta@talentburst.com
679 Worcester Road | Natick, MA 01760 | www.talentburst.com

Certified Minority Business Enterprise (MBE)