Our mission: to be the leader in improving child health.
Senior Database Administrator
Location
California
Posted
4 days ago
Salary
$91.5K - $116.7K / year
Seniority
Senior
Job Description
Senior Database Administrator
Cincinnati Children's
• Responsible for the planning, design, implementation, and maintenance of moderately complex database environments • Ensure that database environments are recoverable and secure • Plan for and monitor the capacity of the database environments • Monitor database and server performance; provide analysis and solutions to performance issues • Plan and execute change within the systems by following the policies and procedures as defined by Information Services • Proactively identify potential issues and conceptualize their solutions while providing direct technical support and problem resolution assistance for all database environments • Develop knowledge and professional skills through cross-training, literature, and attendance at department meetings and vendor education • Develop and maintain positive relationships, both internal and external to CCHMC • Motivate people and encourage teamwork • Prepare oral and written presentations • Conduct and participate in instructional seminars • Develop expertise in several Cincinnati Children's computer-based systems • Manage the design, development, and implementation of new and enhanced projects • Identify the appropriate resources needed to complete projects • Communicate between internal and external parties on project related issues and developments • Develop and maintain project plans • Work with cross functional teams • Consult with end user community to develop requirements for database solutions • Ensure outstanding end-user support is provided, including ongoing monitoring of Service Level Agreements for incident management and collaboration with other areas to ensure customer-centered incident management and support • Adhere to and promote continual adoption of change management policies and procedures • Model outstanding customer service behavior, including timely and effective follow-up with customers • Always maintain CCHMC'S service standards of being Courteous, Attentive, Respectful, Enthusiastic team members and Safe. (CARES) • Mentor and train other database administrators • Participate in the interview process • Provide consultation and assistance to customers and Information Services personnel • Adhere to IS departmental on-call and Service Desk policies and procedures • Perform other duties as assigned.
Job Requirements
- Bachelor's degree in a related field
- 5+ years of work experience in a related job discipline
- 5+ years of experience supporting enterprise database environments, with strong expertise in MySQL, MariaDB, and PostgreSQL
- Experience with high availability, replication, clustering, and load balancing technologies, including MySQL Router and PGPool
- Working knowledge of Oracle Database and Microsoft SQL Server administration
- Experience performing database performance tuning, capacity planning, monitoring, and troubleshooting in complex production environments
- Familiarity with database programming languages such as PL/SQL, T-SQL, and other procedural database languages
- Experience developing and maintaining automation scripts using Bash Shell and/or PowerShell
- Knowledge of Linux and Windows server operating systems and their interaction with database platforms
- Experience troubleshooting issues beyond the database layer, including network connectivity, firewall configurations, operating systems, and infrastructure components
- Experience supporting mission-critical applications in highly available healthcare, research, or other regulated environments
- Demonstrated ability to learn and adapt to new technologies and emerging database platforms.
Benefits
- Comprehensive job description provided upon request
Related Guides
Related Categories
Related Job Pages
More Database Administrator Jobs
• Advanced use of Excel • Build reports and manipulate data • Consult with executives to identify improvement opportunities • Collaborate with team members to analyze data • Visualize data with graphs and infographics • Establish KPIs for decision effectiveness • Structure large data sets • Process information with a team • Craft presentations based on findings
Senior Database Administrator
MastercardFounded in 1966, Mastercard is a worldwide transaction, payment-processing, and consulting company best known for its line of personal and business credit cards. As an employer, Ma
Our Purpose Mastercard powers economies and empowers people in 200+ countries and territories worldwide. Together with our customers, we're helping build a sustainable economy where everyone can prosper. We support a wide range of digital payments choices, making transactions secure, simple, smart and accessible. Our technology and innovation, partnerships and networks combine to deliver a unique set of products and services that help people, businesses and governments realize their greatest potential. Title and Summary Senior Database Administrator Who is Mastercard? Mastercard is a global technology company in the payments industry. Our mission is to connect and power an inclusive, digital economy that benefits everyone, everywhere by making transactions safe, simple, smart, and accessible. Using secure data and networks, partnerships and passion, our innovations and solutions help individuals, financial institutions, governments, and businesses realize their greatest potential. Our decency quotient, or DQ, drives our culture and everything we do inside and outside of our company. With connections across more than 210 countries and territories, we are building a sustainable world that unlocks priceless possibilities for all. Overview Database Engineering manages our databases with a goal to deliver secure, scalable and resilient infrastructure and software deployment capability for global solutions. Provide administration of production, pre-production, UAT and development database systems and assist in designing of the database tier for our global systems Provide a robust, scalable and high-performance production database environment working with system engineers, database developers and other database administrators Role The Senior Database Engineer role has the ability to perform engineering functions where the individual contributes and/or influences the strategic direction for the Database Engineering Program. The individual will build a strong partnership with management and may manage operational and/or strategic initiatives or support for the team. The Lead Database Engineer champions the Mastercard Way. About you• Advanced hands-on experience in configuring, patching, upgrading, and optimizing database software and related products.• Advanced experience in security, backup/recovery, architecture, networking, and administration for assigned database discipline.• Expertise and deep understanding in Database Replication setup, configuration, troubleshooting both Physical as well as Logical Replication• Proven track record in working with technology teams for the development, maintenance, testing, implementation, and support of assigned database technologies and associated software products.• Proactively monitor with advanced troubleshooting skills for database issues escalated by the business team and internal monitoring in a timely manner with strong skills to drive to root cause and remediation of issues.• Ability to develop a strong partnership with technology teams and customer to understand business needs and with advanced skills to communicate solutions in business terms.• Strong to advanced performance and tuning skills with the ability to identify, respond and resolve database performance issues; communicates database performance resolution to technical teams and business partners.• Successfully follow change management, problem management and incident management processes and procedures.• Experience with IAC Automation tools for building automation for DB builds, Patching, maintenances• Ability to handle large to enterprise project/initiatives with specialized knowledge within assigned discipline and the ability to architect solutions.• Advanced written and verbal communication skills to promote Database Engineering.• Proven track record to proactively plan and coordinate larger technical and architectural efforts within the database team and with external technology teams.• Ability to influence Mastercard best practices in planning, coordinating, implementing, and maintaining database solutions.• Proven track record in training and mentoring members of the team by contributing to supporting documentation.• Communicate, collaborate, and work effectively in a global environment.• Creates a positive culture in Database Engineering following the Mastercard Way. Corporate Security Responsibility Every person working for, or on behalf of, Mastercard is responsible for information security. All activities involving access to Mastercard assets, information, and networks comes with an inherent risk to the organization and therefore, it is expected that the successful candidate for this position must:• Abide by Mastercard's security policies and practices• Ensure the confidentiality and integrity of the information being accessed• Report any suspected information security violation or breach, and • Complete all periodic mandatory security trainings in accordance with Mastercard's guidelines. **Desirable Knowledge/Experience**• Experience integrating vendor and open-source products into an overall system• Experience working on cloud-hosted services like AWS, Azure• Database Technologies Include (not limited to): PostgreSQL, Oracle, Cassandra/Elastic Search, Redis, MongoDB, SQL Server, Oracle Exadata Administration, Graph DB. The ideal candidate should have experience in both RDBMS and NoSQL database technologies Corporate Security Responsibility All activities involving access to Mastercard assets, information, and networks comes with an inherent risk to the organization and, therefore, it is expected that every person working for, or on behalf of, Mastercard is responsible for information security and must: - Abide by Mastercard's security policies and practices; - Ensure the confidentiality and integrity of the information being accessed; - Report any suspected information security violation or breach, and - Complete all periodic mandatory security trainings in accordance with Mastercard's guidelines.
• Develop and implement data ingestion solutions using AWS database and cloud-native technologies. • Design, administer, and optimize relational and NoSQL database environments, including Amazon RDS (PostgreSQL, Oracle), Amazon DynamoDB, Amazon Redshift, Amazon Athena, and Amazon S3. • Utilize AWS Database Migration Service (DMS) to migrate, replicate, and modernize database environments. • Research, evaluate, and recommend AWS data storage architectures and database technologies to support business and technical requirements. • Design, develop, test, deploy, and automate database solutions, including infrastructure and database build processes. • Develop automation and administrative scripts using Python and/or Bash. • Monitor database usage, performance, and capacity; conduct performance tuning and provide recommendations for system optimization. • Design and implement indexing strategies, replication, backup, and disaster recovery solutions across multiple AWS Regions. • Develop, test, implement, and maintain SQL code, stored procedures, database applications, and other database objects. • Design scalable, secure, and resilient data models supporting transactional, analytical, and hybrid workloads. • Design, build, and support cloud-based Data Lakes, Data Warehouses, and modern enterprise data platforms. • Lead the design and implementation of modern database architectures that support cloud migration and application modernization initiatives. • Maintain database security, access controls, and data integrity to protect organizational information assets. • Develop and enforce database administration policies, standards, procedures, and governance practices.
Database Developer
Tria FederalTria Federal, founded in 2023, is a technology and advisory services firm specializing in digital transformation solutions for the federal sector. Guided by its commitment to servi
Role Description Tria Federal (Tria) is seeking a talented Database Developer for a key FEMA system. In this role, you’ll be responsible for the evolution of data, including maintaining and improving dozens of SQL scripts, streamlining our data operations, and maintaining our database to ensure peak performance. Qualifications - 7+ years of experience (or 11 total years without a Masters) - Master’s Degree in Information Systems, Computer Science or Computer Engineering or a related discipline - US Citizen - Ability to work in a highly functioning Agile team - Proven track record using MS SQL Server database, creating complex stored procedures, functions, views. Experience with Azure SQL Database is a plus. - Strong communication skills and comfortable presenting to customers both virtually and in-person. - Ability to thrive and create professional resolutions in adverse situations with minimal guidance or oversight. - Computer proficiency, including Microsoft Office tools (Word, PowerPoint, Excel, Project) - Demonstrated ability to write large, complex, high-performing queries. Requirements - Create, improve, and debug scripts to build, move and modify database objects, automating where possible. - Develop complex stored procedures, functions, triggers and views. - Design logical and physical data models along with preparing and presenting statistical information for both internal and external use. - Collaborate with Application Developers to implement best practices with database, statement, and query design. - Providing support, guidance and collaborating with Application Developers to implement database design, and review developer’s work to ensure correct implementation. - Create and apply optimization strategies. - Assist with schema design, code review and query tuning. - Upgrade and improve data and application schema, preparing design documents and functional specifications. - Work in conjunction with the engineering and data science teams to resolve issues, evaluate software modules, and develop appropriate specifications. Benefits - Top-tier benefits package to invest in your physical, mental, and financial health and wellness. - Opportunities to learn new skills, seize new challenges, and advance your career as we grow.



