Database Administrator III Job Listing at City National Bank in Los Angeles, CA (Job ID 89309)

Description

If you are hired to this position, you will be employed by Magnit Global. You will not be employed by City National Bank.

The Opportunity

This role primarily works with Application teams, as well as Database Administration, Development, Architect, Security and Audit teams for existing or new production and development environments that are On-Premise and Microsoft Azure. You mill monitor and support SQL Server uptime for applications, and provide Root Cause Analysis (RCA) to requesting teams as needed. Additionally, in this role you'd administer and manage complex database systems; create, manage, and monitor performance and tuning of databases. Responsible for data warehousing design, data architecture strategy design and capacity planning.

The Responsibilities

• Ensures availability, security and integrity of assigned databases.
• Implements data models and database designs and enables applications with efficient back-end access and processing.
• Resolves database performance, capacity, replication, and other distributed data issues.
• Installs and configures database management software (DBMS) and applicable service packs and/or patches.
• Develops and implements database maintenance plans, including performing integrity checks, updating statistics and monitoring security and hardware resource utilization.
• Establishes regular backups of databases and transaction logs.
• Manages logins and user accounts, including assigning database object permissions and ancillary privileges.
• Schedules and manages jobs for data transfers and sundry procedures and monitors performance and impact on operations.
• Participates in data modeling and database logical and physical design.
• Participates in application development processes and code reviews of database objects.
• Analyzes long-term database performance trends to optimize database and application performance.
• Configures database server to work with middleware, web servers and OnLine Analytical Processing (OLAP) tools.
• Configures, supports, and optimizes replication. • Performs acceptance testing on computer systems, applications and hardware.

The Qualifications

• Will typically have a B.S. in Computer Science, MIS or related degree and a minimum of three (3) years of related experience including relational database theory and relational database programming experience
• Physical and Virtual machines SQL Server and Windows Server performance monitoring, configuration management, and performance tuning
• Forecasting SQL Server resource utilization and providing supporting evidence or reports for capacity planning
• TSQL performance tuning
• Powershell
• SQL Server upgrades
• Performance Monitoring for OS, SQL Server or SQL workflows.
• SQL Server licensing
• SQL Jobs and Maintenance Plans
• SQL Server patching
• SQL Server 2012, 2014, 2016, 2017 and 2019
• SQL Server Reporting Services
• SQL Server Integration Services
• Windows and SQL Server clustering
• SQL Server Disaster Recovery
  • Log Shipping
  • SQL Server Mirroring
  • Always on Availability Groups
• Microsoft SQL Azure Managed Instances
• Microsoft Azure
  • Monitor
  • Metrics
  • Key Vault
  • Storage
• Idera SQL Diagnostic Manager
• Zerto for disaster recovery
• Azure DataFactory
• Azure DevOps pipeline
• Redis Cache
• Cosmos
• Kubernetes
• VMWare
• Jira (Agile)

This is the pay range that Magnit reasonably expects to pay for this position: $72.92/hour - $78.17/hour

Benefits: Medical, Dental, Vision, 401K