Citizens Financial Group-posted 1 day ago
Full-time • Principal
Hybrid • Phoenix, AZ
5,001-10,000 employees

As a Principal Database Engineer, you will design, develop, and implement platforms, systems, and pipelines to enable data capture, access, and analysis. This role combines deep mainframe expertise with cross-platform database support and modernization initiatives, including cloud migration.

  • Administer and maintain Mainframe Db2 z/OS databases, including performance tuning, backup/recovery, and security.
  • Provide cross-platform database support for SQL Server, Oracle, PostgreSQL, and AWS RDS.
  • Develop and optimize complex SQL queries, stored procedures, and scripts for data analysis and application support.
  • Collaborate with application development, infrastructure, and cloud teams to support database integration and modernization efforts.
  • Implement and manage database automation, monitoring, and alerting tools.
  • Participate in disaster recovery planning, testing, and execution.
  • Ensure compliance with data governance, security policies, and audit requirements.
  • Lead or contribute to cloud migration projects, particularly involving AWS database services.
  • Provide on-call support and incident response for critical database issues.
  • 7+ years of experience as a DBA with strong hands-on expertise in Mainframe Db2 z/OS.
  • Proficiency in SQL and performance tuning across multiple platforms.
  • Experience supporting SQL Server, Oracle, PostgreSQL, and AWS RDS.
  • Solid understanding of AWS cloud architecture, especially database services such as RDS.
  • Familiarity with JCL, Top Secret, TSO/ISPF, and other mainframe utilities.
  • Experience with database backup/recovery strategies, high availability, and disaster recovery.
  • Strong analytical and troubleshooting skills.
  • Excellent communication and documentation abilities.
  • Extensive experience with SQL and NoSQL databases (Cassandra, MongoDB, Postgres, InfluxDB, Neo4j).
  • Understanding of the banking industry, specifically custodial and consumer banking functions.
  • Experience with cloud computing technologies, Hadoop ecosystem, and workflow management tools such as Luigi and Airflow.
  • Experience with agile development methodology.
  • Experience with CICD pipelines (CircleCI, Jenkins, or equivalent).
  • Experience with Elastic Stack or other front-end development tools.
  • We offer competitive pay, comprehensive medical, dental and vision coverage, retirement benefits, maternity/paternity leave, flexible work arrangements, education reimbursement, wellness programs and more.
  • Note, Citizens’ paid time off policy exceeds the mandatory, paid sick or paid time-away policy of every local and state jurisdiction in the United States.
  • For an overview of our benefits, visit https://jobs.citizensbank.com/benefits .
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service