SQL Server DBA II

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 :

Preferred :

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.