Randstad Database Developer in San Diego, California

Database Developer


San Diego, CA

Date Posted:

Wednesday, October 12, 2016

Job Type:


Reference #:



Randstad Technologies

apply now


Position Summary:

The Database Administrator performs database and software life-cycle activities to ensure the highest level of system performance and availability in compliance with business requirements. This position partners with other Information Technology team members to accomplish planning, implementation and maintenance of database related infrastructure for legacy and new business application systems. This position is responsible for maintaining the integrity, security and availability of multiple databases. Other key job duties include disaster recovery, performance analysis and tuning, index maintenance and monitoring of data.

Essential Duties and Responsibilities include the following. Other duties may be assigned.

· Creates, monitors, and maintains company databases by responding to a variety of internal and external database customer requests and assignments from management

· Provides database back-up, archiving, monitoring, data analysis and troubleshoots data issues

· Main responsibilities include working with company defined (Oracle) software installations, user and schema creation, maintenance, and auditing, data mapping, loading, and quality control, backup and recovery, space and runtime performance tuning, monitoring and maintenance of data replication processes and development of supporting scripts and procedures

· Assists with related task planning, training and technical direction of other DBA s or IT software engineers and developers

· Provides technical leadership and advice for the company s use of relational database and related technologies

· Provides leadership and guidance on large, complex and cross functional projects and tasks

· Researches and recommends current and trending database technologies that offer the organization ways to improve its level of service to customers and maintains its leading edge over competitors

· Implements data models and database designs, data access and table maintenance codes

· Resolves database performance issues and errors, database capacity issues, replication, and other distributed data issues

· Provides performance tuning and capacity planning services, leads conversions and upgrades

· Develops documentation for the assessment and automation of repeatable processes

· Drives the development of (and adherence to) data modeling standards, methods and practices

· Assists in maintaining plans for disaster recovery and failover capabilities and testing

· Plans, performs and implements data modeling

· Maintains security according to company guidelines and works closely with the IT Security team to develop additional robust solutions

· Analyzes, validates, creates, and designs data models, structures, and processes. Documents findings and recommendations for use in decision making and further system design

· Provides peer reviews for work produced by other DBA s and/or software engineers

· Develops, documents, automates, and assesses DBA processes while looking for ways to improve current processes and streamline efforts

· Trains others on the IT DBA Team and within the Information Technology department on databases related to repeatable processes

· Acts as a mentor to less experienced DBA staff and/or staff in other IT functions

· Provides on-call support after hours and on weekends (on a rotational basis) per the department s on-call agreement to meet SLA s and metrics

Support the colocation data center migration project, and the implementation of new server and database technologies, standards and configurations.

Special Skills Required:

· Oracle Database and ASM Administration

· SQL & PL/SQL coding for data management and manipulation

· Troubleshooting and resolving database problems

· Performance Tuning and Optimization (PTO), using native Monitoring and troubleshooting tools

· Backups, restores and recovery models

· Knowledge of High Availability (HA) and Disaster Recovery (DR) and Replication options for Oracle Databases

· Experience with database Appliances

· Experience with database cloning technologies

· Implementing operational automation using scripts

· Knowledge of indexes, index management, and statistics

· Experience working with Unix/Linux and/or AIX servers, and proper disk configurations

· Good communication and documentation skills

· Unix Shell Scripting

Education and/or Experience

A Bachelor s degree (or equivalent combination of education and job related experience) along with twelve (12) plus years job related experience. Prior experience in a Technical Lead capacity is desirable.

apply now