DBA - SQL Server DBA II - P2

Credit One Bank; Las Vegas (NV); On-site; USD 89,000 - 166,000; Full time

Job summary

A leading financial services company in Las Vegas is seeking a SQL Server Database Administrator to develop and maintain corporate SQL Server databases. The role involves ensuring data integrity, security, and recoverability while optimizing database performance. The ideal candidate will have extensive experience with SQL Server, strong communication skills, and the ability to work in a fast-paced environment. This position offers a chance to contribute to significant database projects and enhance the company's data architecture.

Qualifications

• 4+ years SQL Server DBA experience required.
• Knowledge of SQL Server versions 2012-2022 and migration benefits.
• Experience with database security and access strategies.

Responsibilities

• Administer database installation, configuration, and upgrades.
• Perform proactive database monitoring and issue resolution.
• Develop and implement database security policies.

Skills

T-SQL

PowerShell

Performance Tuning

Database Management

Communication

Education

Microsoft Certified Database Administrator (MCDBA)

Tools

SQL Server Manager

Visual Studio

SQL Profiler

SSIS

SSAS

SSRS

Job description

Description

Position Summary

The primary objective of the SQL Server Database Administrator (SQL DBA) is to develop and maintain the corporate SQL Server databases ensuring data integrity, security, retention, and recoverability of the data.

In this role, the DBA will design, build, test, and deploy quality database solutions that are consistent with project objectives, technology architecture standards, and departmental best practices. The DBA will design and implement database strategies, administer enterprise-wide data architecture, implement complex data structures, and provide daily management of corporate databases.

The DBA will create and administer database objects from design to deployment utilizing subject matter expertise to design or re-use, configure, and implement database solutions/processes that maximize system availability, efficiency, effectiveness, integrity, recoverability, and supportability.

Essential Job Functions

• Apply All aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup, and recovery.
• Work 24x7 rotational on-call support, including driving Root Cause Analysis (RCA), Preventative action follow-through, and participation in weekly operations reviews.
• Change management including maintenance of multiple development, test, QA, and production environments. Responsible for deploying approved changes to production.
• Proactive database monitoring and issue resolution
• Database and T-SQL optimization including performance tuning, query optimization, and supportability.
• Actively participate and contribute to projects involving enterprise database systems enhancements to meet business requirements. Participate in project design and SQL Server database design decisions.
• Develop and implement Database security policies and procedures, in line with corporate objectives
• Responsible for evaluating patch releases and patching requests from development, and communicating constraints, issues, and timelines for deployment.
• Implementation and ongoing support of high availability architecture standards and technologies.
• Create and maintain appropriate documentation about the database and the data architecture.
• Support data management solutions including ETL processing, data archive, data purge, etc.
• Regular proactive capacity planning and tending reviews of all SQL Server databases. Producing weekly, and monthly management reports.
• Work on project sizing processes - including design reviews as necessary to appropriately size new environments, recommend design strategies and deliver associated cost and resource effort estimates.
• Perform other duties as assigned.
  
  

Position Requirements

• Must have 4+ years SQL Server DBA working experience with SQL Server.
• Must be knowledgeable and experienced in the different versions of SQL Server (2012 - 2016). Knowledge of upgrading to SQL Server 2019 & 2022 and benefits to the migrating to these environments.
• Must have skills and experience in Database data management – backups, ETL, and archive using native SQL Server backup tools.
• Experienced using internal diagnostic and maintenance tools such as DBCC and internal SP functions as well as SQL Diag, SQL Profiler, and third-party diagnostics tools.
• Demonstrate Knowledge of Partitioning Architecture.
• Experienced in collaborating with data warehousing developers. Knowledge of BI toolsets including SSIS, SSAS, SSRS, and MS SharePoint.
• Management of multiple processing schedules and notification strategies. Strong skills in T-SQL, DOS, PowerShell, tuning, and debugging. Experience with SQL Server Manager, Visual Studio, DTS/SSIS, and other SQL Server tools including but not limited to Profiler & SQL Server Command Line Utilities
• Experience with SQL Server database replication and mirroring
• Experienced in security/access strategies for a wide pool of user groups and developers with different access requirements.
• Ability to maintain a positive attitude while working with high demands and short deadlines
• Ability to prioritize heavy workload with minimum supervision
• Highly adaptable with the ability to work in a fast-paced demanding environment
• Must have excellent communication and interpersonal skills
• Ability to work well with development and infrastructure teams in doing database design, changes, and enhancement to new and existing applications.
• Strong organizational and analytical skills.
• Understanding of High Availability and Disaster Recovery requirements and solutions.
  
  

Preferred

• Microsoft Certified Database Administrator (MCDBA) or higher certificates on SQL Server 2012+.
• Experience in data modeling and metadata management.
• Understanding of or experience supporting .NET applications.
• Understanding of or experience with virtual environments.
• Experience with Oracle DBA and Oracle support is a strong plus
  
  

Credit One Bank, N.A. is a data-driven financial services company based in Las Vegas. Founded in 1984, Credit One Bank offers a spectrum of credit card products for people in all stages of financial life. Credit One Bank is an equal opportunity employer committed to diversity and inclusion and does not discriminate against any employee or applicant for employment because of age, race, religion, color, disability, sex, sexual orientation, or national origin. Reasonable accommodations can be made for those who require them, including access to job applications and workplace accommodations. Employment at Credit One Bank is based on mutual consent (also known as at-will). This means that employees and the Bank may terminate the employment relationship at any time, with or without cause and with or without notice. Please contact the recruiter for this position to learn more. Credit One Bank does not accept unsolicited resumes from agencies and is not responsible for related fees.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

Referrals increase your chances of interviewing at Credit One Bank by 2x

Get notified about new SQL Database Administrator jobs in Las Vegas, NV.

SQL Server DBA (SQL Server Database Administrator)

Las Vegas, NV CA$50.00-CA$50.00 5 days ago

SQL Server DBA (SQL Server Database Administrator)

North Las Vegas, NV CA$50.00-CA$50.00 5 days ago

SQL Server DBA (SQL Server Database Administrator)

Henderson, NV CA$50.00-CA$50.00 5 days ago

Las Vegas, NV $114,816.00-$165,845.00 1 month ago

Las Vegas, NV $89,301.33-$114,816.00 1 month ago

Oracle Sql Server Database Administrator

Las Vegas, NV $100,000.00-$115,000.00 3 days ago

Las Vegas, NV $112,597.33-$152,810.66 1 month ago

Las Vegas, NV $144,768.00-$209,109.33 1 month ago

Las Vegas, NV $134,784.00-$194,688.00 1 month ago

Las Vegas, NV $144,600.00-$241,000.00 5 days ago

Las Vegas, NV $104,832.00-$142,272.00 1 month ago

Las Vegas, NV $105,100.00-$192,700.00 1 week ago

Las Vegas, NV $108,714.67-$139,776.00 1 month ago

Las Vegas, NV $149,760.00-$216,320.00 1 month ago

Las Vegas, NV $116,480.00-$149,760.00 1 month ago

Las Vegas, NV $139,776.00-$201,898.00 1 month ago

Las Vegas, NV $106,773.33-$144,906.66 1 month ago

Las Vegas, NV $131,040.00-$168,480.00 1 month ago

Las Vegas, NV $137,280.00-$198,293.33 1 month ago

Las Vegas, NV $137,280.00-$198,293.00 1 month ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.