DBA Operations

Job Description

Neustar is looking for a skilled individual to work in a highly dynamic environment providing support for development through production level Oracle databases. Additional supporting 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. The candidate will be responsible for the performance, integrity, and security of over 700 databases across many business services. The candidate is expected to ensure data recovery, maintenance, data integrity, and space requirements are met through formulations and monitoring of policies, procedures, and standards relating to database management. Has a willingness to work with customers of varying levels of technical expertise in a high- pressure, complex environment. The candidate will have experience with or have a desire to learn open source database technologies such as MySQL, Postgres, GreenPlum and Mongo. Responsibilities: Periodic on- call support responding to incidents and incident bridges Change Management implementation. Changes are frequently implemented outside business hours and overnight. Provide first- level database support: Resolve problems and answer questions related to the database and platform environment (Linux, AIX, VMware), contact vendor support when necessary; facilitate application 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. Database 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 database and related products: Keep database 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 Ability to design and implement backup and recovery of databases 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 Knowledge of SQL, including programming and ways to optimize SQL code. Ability to quickly learn, adapt to, implement and migrate current database technologies to new open source environments, specifically Postgres, MySQL and Mongo Required Experience: Bachelor s degree or better in Computer Science, Engineering or related discipline 3 years in- depth experience in administration and support of Oracle Enterprise RDBMS 1 years extensive experience in at least 2 of the following technologies: ASM, RAC, GoldenGate, DataGuard 3 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 Preferred Skills: Experience in Agile management methodologies Experience with ServiceNow Experience with Jira and Confluence Neustar does not accept unsolicited resumes from external firms or agencies. Neustar will not be responsible for placement fees associated with unsolicited resumes. DIVERSITY 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. EOE of Minorities/ Females/ Vets/ Disability 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.,

Keyskills :
unixshellscriptingsqlserverdataguardopensourcedatarecoveryshellscriptingcomputersciencechangemanagementtronginterpersonalskillsgoldengatefilesystemfederallawdataintegritycapacitypl