Sr. DBA/ Developer

Glendale, CA 91202

Employment Type: Perm Job Category: Other Area(s) Job Number: 20307

Job Description


SUMMARY:  The Sr. Database Developer / Administrator will be involved in providing high-quality, innovative, and highly performing dynamic data models and database designs, as well as, delivering high-scalability, performance tuning, and scripting for all of the back-end production databases

JOB DUTIES& RESPONSIBILITIES:
• Execute full lifecycle software development practices and standard operating procedures.
• Write well designed, testable, efficient database queries, code, and scripts.
• Produce specifications (with detailed workflow charts or UML diagrams) and determine operational feasibility and scalability.
• Understand the full system architecture and continue to strive for “ light” and “ nimble” database design, while maintaining 999’ s of availability.
• Timely interaction with software engineers, team and business leads from the various engineering and product teams in order to understand their database requirements for new products or features.
• Designing logical data models and solutions and creation of the physical design and maintaining the entire model.
• Focused primarily on PostgreSQL database technology to power our high-volume, business-critical web sites and systems
• Planning detailed deployments with database and software engineers that use advanced techniques to minimize or eliminate downtime when making schema changes
• Implementing the schema changes in development, thoroughly testing DDL scripts, including scripts to rollback changes and to ensure no single point of failure
• Ensuring always on architecture, fast performance, flexibility data storage and distribution with the ability of the databases to scale elastically with the web traffic
• Evaluating new database technologies and tools to meet growing challenges
• Developing and implementing scripts for database maintenance, performance tuning, monitoring, etc

QUALIFICATIONS/SKILLS:
• To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.
• Proven work experience as a computer database administrator
• Hands on experience in designing relational schemas and indexing for a dynamic data model supporting a vast quantity of products, options and manufacturing rules.
• Has knowledge of commonly-used concepts, practices, and procedures within the software development field.
• Ability to work effectively in a coordinating role across multiple disciplines, a strong, open and collaborative work style, customer-service orientation with the ability to translate business goals into information management requirements
• Demonstrates initiative with or without direct authority
• Demonstrates creativity in solving problems or generating improvement ideas
• Self-motivated time management
• Supports and maintains positive attitude and vision with peers, associates, and management
• Ability to prioritize competing or conflicting requests and execute tasks in a high-pressure environment
• Utilizes good judgment
• Must demonstrate ability to handle diversity amongst people and environments
• Must be detail oriented and able to follow-up and follow-through on project actions and tasks
• Ability to work within and adapt quickly, either in a team environment or individually, to meet deliverables/schedules.
• Ability to produce clean, well-documented, efficient, and standards-compliant code – with an eye towards performance optimization.
• Ability to maintain confidentiality of sensitive information.
• Extensive written and oral communication skills


EDUCATION & EXPERIENCE:
• Bachelor’ s degree in Computer Science, Computer Engineering or related field
• 4-7+ years of experience working in database administration
• Experience with agile methodologies & full SDLC experience
• Experienced with PostgreSQL or another database system, query authoring, optimization of query plans and indexing
• Has applied virtualization technologies such as AWS, Vagrant, VMware, VirtualBox, or Docker in development and production
• Experience working with databases in a 24x7 online environment is essential
• Strong conceptual database hands-on experience with minimum of 3 years’ experience working with PostgreSQL, preferably 9.2+, or some other RDBMS: MS-SQL, MySQL or Oracle
• Strong conceptual and working knowledge of building logical and physical data models
• Strong Working knowledge of UNIX/ Linux (4-7 Years), scheduling cron jobs, basic troubleshooting etc.
• Understanding of the data architecture needs of RESTful development, specifically with PHP, Symfony 2+

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.