Senior Database Admin (MongoDB, MySQL, PostgreSQL)
Clear Channel Communications - Los Angeles, CA

This job posting is no longer available on Clear Channel Communications. Find similar jobs: Senior Database Admin jobs - Clear Channel Communications jobs

Clear Channel Digital, a division of Clear Channel Media & Entertainment is looking for Senior Database Administrator to report to our Los Angeles Office.

The DBA will be working in a high volume transactional environment supporting web and mobile applications. This role will be responsible for managing multiple MongoDB, MySQL, and PostgreSQL database servers which provide content to 1000+ public facing websites. The candidate will be tasked with server upgrades, performance monitoring/tuning, testing and change deployment. Must be comfortable working in a constantly evolving environment where changing business requirements demand support from the underlying technology. The ability to think quickly and solve complex technical problems is essential to this role.

  • Provide administration support for high volume transactional and analytical database servers
  • Manage database installations and upgrades
  • Data modeling (logical and physical), optimization of legacy data models and stored routine development
  • Manage database objects including tables, relationships, stored routines, triggers and users/roles
  • Query optimization including tuning legacy application code and analyzing underperforming query reports
  • Test database components by providing quality assurance, benchmarking, validation, monitoring
  • Must be available to provide after hours support within an on-call rotation
  • Provide database support in person, over the phone, or via email as necessary
  • Assist development team with recommendations on best practices
  • Manage database security and implement audit requirements
  • Database server performance tuning
Job Category:
Information Technology

Los Angeles, CA

Media & Entertainment

Employment Status:

Job Requirements:REQUIRED SKILLS:
  • Ability to solve problems independently or as part of a team
  • Exceptional oral/written communication, organizational, and interpersonal skills to drive results in a multi-disciplinary environment
  • Ability to prioritize multiple tasks and projects and deliver under deadline
  • Strong understanding of relational databases
  • Understanding of MySQL internals including storage engine architecture (MyISAM, InnoDB, archive), partitioning, indexing, referential integrity, networking and caching
  • Understanding of MySQL database replication internal processes including binary/relay logging, replication threads, row/statement based replication, master/slave topologies
  • Experience with Slony and PostgreSQL streaming replication
  • Familiar with MongoDB or other NoSQL databases
  • Familiar with high availability and scalability concepts such as clustering and load balancing
  • Understanding of various disaster scenarios, backup/disaster recovery techniques/topics including logical/physical backups, point-in-time recovery, data corruption
  • Experience with Linux operating systems (CentOS, RHEL), Bash shell scripting, installing/upgrading software, security, understanding of Linux file system architecture
  • Familiar with database transactions and concepts: table/row locking, semaphores, mutual exclusion, ACID, disk I/O
  • General knowledge of hardware components and connectivity including disk, CPU, networking, memory, switches, etc
  • Significant life-cycle database administration support including database design, database development, testing, deployment, and maintenance
Education Requirements:EXPERIENCE & EDUCATION:
  • 5+ years IT industry experience
  • 3+ years database administration experience
  • College degree or equivalent experience
  • Experience with object oriented programming, PHP 5, JavaScript, or Java
  • Knowledge of dimensional modeling, warehousing/OLAP environments and database sharding techniques
  • Conceptual understanding of shared storage, Logical Volume Management (LVM), virtualization and distributed caching
  • Oracle administration experience
  • MS SQL experience
Medical, Dental, Vision, Life, 401k, EAP, Paid Vacation and Sick Leave

Clear Channel Communications - 2 years ago - save job
About this company
93 reviews
This company leaves few open channels on the radio dial. Clear Channel Communications is the #1 radio company in the US, with about 860...