Senior Database Administrator
Boingo - Los Angeles, CA

This job posting is no longer available on Boingo. Find similar jobs:Senior Database Administrator jobs - Boingo jobs

The Senior Database Administrator will concentrate on designing, implementing, managing and supporting production and QA database systems including Oracle, MySQL and SQL Server.

Candidates for this position should enjoy:
  • Working closely with Boingo teams across the organization, including Business Intelligence, Operations and Engineering
  • Being able to see how your work directly benefits business objectives
  • Uses skills to design and implement database systems that support business objectives
  • Use creative thinking to identify opportunities to optimize current environments or implement enhancements for increased productivity

Responsibilities:
  • The Senior Database Administrator will primarily be involved in designing, implementing, managing and supporting production and QA database systems including Oracle, MySQL and SQL Server.
  • Assist development teams with application deployments and issue resolution
  • Maintain and monitor performance, space utilization, uptime and availability of all database systems. Report on all performance metrics.
  • Maintain database backup jobs and ensure the integrity of backups
  • Build and maintain data synchronization and replication between multiple locations for large production database environments
  • Develop and document database administration procedures that meet requirements and adhere to defined policies
  • Maintain documentation for all database instance parameters and system settings
  • Development of private and hybrid database cloud solutions
  • Provide security administration including managing role and end user database permissions in accordance with customer policies
  • Implement and administer appropriate DB management tools across all DB instances
  • Identify and resolve locking conflicts, latch contention, rollback requirements, etc., for all DB instances
  • Patch database software as needed according to established development to QA to production life cycle
  • Manage database software configuration, installation and maintenance
  • Work closely with BI team to design schemas, tables, tune queries, write database code, and archiving data
Requirements:
  • Experience with task automation scripting using Python, Perl, Shell, or other UNIX based languages
  • In-depth knowledge of database systems, including high-availability design/operation, performance tuning, capacity planning, automated back-up and recovery
  • Expertise with replication, active/passive clustering, disaster recovery
  • System administration skills required to troubleshoot database related problems at the OS level, on Linux/Unix/Windows, and commercially available server and storage systems
  • Experience performing 24x7 production support for Oracle & MySQL & MS SQL Server environments
  • Experience with database monitoring tools including Oracle Enterprise Manager (OEM), Splunk, etc.
  • Experience with database capacity scaling techniques such as caching, data partitioning and clustering
  • 5+ years Oracle experience including design, implementation, backup and recovery, monitoring, and tuning databases
  • 2+ years experience in OS or database administration
  • 2+ years experience with managing databases in virtual and cloud environments (VMware, RDS, EC2)
  • Experience participating as a subject matter and technical expert in technical reviews of physical database models
  • Strong written and verbal communication skills are a must as is a demonstrated ability to work effectively with cross-functional teams
  • Strong analytical and troubleshooting skills
  • Ability to work well independently, as well as cooperatively with others
  • Ability to meet deadlines in a fast-paced environment
  • Bachelors and in Computer Science, Information Systems, or several years of equivalent experience
Nice to haves:
  • Oracle Database Administration certification (OCP) preferred
  • Telecom billing experience, especially usage based billing
Location: Los Angeles, CA