Oracle DBA Position
Neustar is looking for a skilled, highly motivated and dedicated individual to work in a dynamic environment providing operations support for development through production level databases.
This person should have a strong desire to learn and ability to work in a fast-paced, team-oriented environment. This is a unique opportunity for someone to gain exposure and experience on some of the latest database technologies including Oracle, Postgres, MySQL, NoSQL and Amazon AWS.
We are looking for intellectually passionate people who learn quickly, thrive in a fast-paced environment, and stay current with the latest technologies.
The job requires providing primary operational support for Oracle technologies include Data Guard, Golden Gate, Materialized Views, Real Application Clusters (RAC) and Automated Storage Management (ASM).
Additional skills in Postgres, MySQL, SQL*Server and Mongo database administration are highly desired.
Provide operational tier 2 database support.
Resolve problems and answer questions related to the RDBMS and platform environment (Linux and VMware), contact vendor support when necessary;
facilitate database development and client problem resolution with optimum speed and efficiency
Maintain database backup / recovery environment : Assure that data recovery time objectives are established and met; verify implementation of correct backup strategy;
develop recovery procedures; support recovery from loss of data caused by user or system error; respond quickly to refresh data.
RDBMS performance monitoring and tuning : Closely monitor performance; identify problems and implement solutions; ensure the database is running at optimum speed and efficiency
Install and upgrade RDBMS and related products : Keep RDBMS at current release and maintenance levels; install supporting products;
provide current, stable production and development environments
Reorganize database structures as needed : Automate procedures at regular intervals; use tools to reorganize or defragment database table spaces, tables, and indexes;
provide efficient database environment to maximize productivity and improve performance
Perform application refreshes on request : 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 pre-scheduled time to minimize impact;
provide application development staff optimal development environment with current data
Capacity planning and reporting : Monitor file system space, database allocation, etc.; verify efficient use of disk storage;
reclaim unused space; optimize space allocation and avoid out-of-space conditions
Work closely with Systems Programmers and Systems Administrators to ensure that the database system is operating in accordance with required system usage;
provide assistance and guidance in setting appropriate system parameters
Review overall physical database structures for data integrity, performance quality, recoverability, maintenance, and space requirement considerations
Communicate complex technical information in a concise and articulate manner
Participate in the evaluation and recommendation of DBA tools and new DBMS technologies
Skills and Knowledge :
Thorough understanding of the relational database model and solid theoretical knowledge of relational database techniques;
skilled in ability to see the big picture and conceptualize and document creative solutions
Extensive experience in logical and physical database design, hands-on data modeling techniques, and development methodology;
physical schema design of table spaces, rollback segments, and data files
Ability to design and implement backup and recovery of RDBMS under various failover and switchover events.
Excellent oral and written communications skills
Strong interpersonal skills at all levels of management and ability to motivate employees / teams to apply skills and techniques to solve dynamic problems;
excellent teamwork skills
Ability to weigh various suggested technical solutions against the original business needs and choose the most cost-effective solution
Extensive knowledge of SQL, including programming and ways to optimize SQL code.
Ability to quickly learn, adapt to, implement and migrate current RDBMS technologies to new open source environments, specifically Postgres
Bachelor’s degree or better in Computer Science, Engineering or related discipline
2+ years in-depth experience in administration and support of Oracle Enterprise RDBMS
1+ years extensive experience in at least 1 of the following technologies : ASM, RAC, GoldenGate, DataGuard
2+ years operating knowledge of various UNIX environments, specifically RedHat and CentOS
2+ years UNIX shell scripting experience
Demonstrated experience working well with customers of varying levels of technical expertise in high-pressure situations and complex environments
Skills in development languages such as Perl, PHP, Ruby, C, C++ desired but not required
Neustar does not accept unsolicited resumes from external firms or agencies. Neustar will not be responsible for placement fees associated with unsolicited resumes.
Diversity, inclusion and teamwork are second nature to Neustar; and these values permeate our entire business structure.
Neustar is committed to creating an environment where a wide spectrum of opinions and beliefs are actively sought, listened to and respected.
Further, our talented workforce draws from the many geographic areas and markets in which Neustar operates worldwide, which represents a distinct competitive advantage.
The rich and varied personal and professional backgrounds of our employees make Neustar a dynamic and rewarding company at which to build a career. We invite you to join us.
Neustar, Inc. considers all applicants for employment without regard to race, color, religion, sex, national origin, age, disability, sexual orientation, or status as a Vietnam-
era or special disabled veteran in accordance with federal law and other state and local requirements. Neustar, Inc., complies with applicable state and local laws prohibiting discrimination in employment and provides reasonable accommodation to qualified individuals with disabilities in accordance with the American with Disabilities Act (ADA) and applicable state and local laws.