Information Systems/Technical Services: IT Database Management/Services
Database Administrator - Tickets.com (New York, NY)
Tickets.com is a privately held subsidiary of MLB Advanced Media, LP, the interactive media and Internet division of Major League Baseball.
At Tickets.com, we’re a passionate bunch of people, driven by a relentless pursuit of innovation. Our mission is to deliver world-class ticketing products and services that provide value to our clients and partners, with profitability to our stakeholders.
We're headquartered in beautiful Orange County, California, with offices in the state of New York, across Europe, and in New South Wales, Australia. We enjoy a fun and casual work atmosphere, and we pride ourselves on working hard to deliver quality results.
We are searching for a Database Administrator with Sybase, MS SQL Server and Oracle experience. This position will be responsible for the design, architecture, performance, recoverability and availability of database management software (mainly Sybase, Microsoft SQL Server and Oracle databases).
If you think you’re a good fit for the position and the team, we’d love to hear from you!
Essential Job Functions:
Participate in the design of the data model and operational architecture used by our software products in conjunction with our software and systems engineering team
Participate in the planning of software projects (provide estimates, document portions of project plans for use by project managers, etc)
Ensure all Development/QA/UAT/Production databases are recoverable, properly tuned and configured
Perform analysis and tuning of all new queries introduced by a new software release to ensure maximum performance and throughput (ensure SQL is optimized, new indices are in place, etc)
Administer and support Protobase credit card gateway software
Create scripts used to apply all new DDL & DML changes to non-production and production environments as needed for a given release
Understand exactly how all applications interface with its database, and how all tables/columns are used for the various business functions performed by the software products (and document)
Deploy database object changes to the QA/UAT/Production environments for each new software release
Monitor DBMS health on an ongoing basis and respond promptly and proactively to problem alerts
Utilize source control tools as necessary for document and code storage
Resolve complex database problems/configuration via advanced debugging techniques
Write technical documentation under the guidance of Sr. DBA’s and Information Manager, such as data dictionaries, database configuration specifications, upgrades, project plans, etc
Keep abreast of new industry developments and standards activities that affect the organization
Manage nightly, weekly and monthly backups of databases
Perform operational duties such as user access audits, environment deployments, and storage capacity management
Participate in weekly 24x7 on-call support rotation
BS in Computer Science, or equivalent
Minimum of three (3) years of experience with any relational database systems on Unix, Linux and Windows
Sybase, MS SQL Server and Oracle DBA experience required
MySQL and PostgreSQL experience a plus
Protobase experience a plus
Understanding of SQL-Plus and Transact SQL
Understanding of Data Definition Language (DDL) and Data Manipulation Language (DML)
Experience with debugging techniques
Knowledge of replication solutions such as Oracle Streams and 3Par SAN replication
Exceptional teamwork and communication skills
Remote evening and weekend work as required including having high speed home internet access
Skilled in the use of Oracle OEM, SQL Server Management Studio, dbArtisan and other database monitoring and administration tools a plus
Tickes.com is an Equal Opportunity Employer.
MLB - 11 months ago
This company is ready to play ball online. MLB Advanced Media (MLBAM) is the Internet and interactive media arm of Major League Baseball (M...