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

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

QUALIFICATION/LICENSURE

Work Authorization : Green Card, US Citizen, Other valid work visa
Preferred years of experience : 3 years
Travel required : No travel required

• 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