At Credit One Bank, the SQL Server DBA II position stands as a cornerstone within our Database Operations team, ensuring the robustness of systems that underpin our credit card services and financial operations. Nestled in Las Vegas, this role supports a high-volume environment where precision meets innovation, collaborating closely with developers and cybersecurity experts to maintain data integrity amid growing transaction demands. What sets this opportunity apart is its focus on proactive tuning for peak-hour loads specific to our Nevada-based operations. Day-to-day, you'll monitor SQL Server instances using advanced tools like SQL Server Management Studio and Performance Monitor, diagnosing bottlenecks in real-time to prevent service disruptions. Expect to design and implement high-availability clusters with Always On Availability Groups, tailoring failover strategies to our 24/7 banking cycles. You'll script automation routines in PowerShell for routine maintenance such as index rebuilds and statistics updates, freeing resources for strategic projects. Partnering with application teams, you'll migrate legacy databases to Azure SQL Managed Instances, optimizing costs while scaling for seasonal credit promotions. Troubleshooting complex query performance involves deep dives into execution plans, collaborating with BI analysts to refine data warehouse queries. Additionally, you'll conduct security audits, applying patches and configuring Transparent Data Encryption to comply with PCI-DSS standards vital for our cardholder data. On larger initiatives, lead capacity planning for upcoming CRM integrations, forecasting storage needs based on historical Vegas market trends. Candidates must hold a bachelor's degree in computer science or a related field, coupled with at least five years of hands-on SQL Server administration in a production environment. Proficiency in SQL Server 2019 and later versions is essential, including expertise in T-SQL programming and query optimization. Familiarity with hybrid cloud setups, particularly Azure integration, along with experience in backup strategies using Veeam or native tools, sets strong applicants apart. Relevant certifications such as Microsoft Certified: Azure Database Administrator Associate or MCSA: SQL Server enhance candidacy. Knowledge of financial sector regulations like SOX and GLBA ensures alignment with our compliance-driven culture. Technical prowess extends to mastering replication topologies and extended events for auditing, alongside scripting for disaster recovery drills. Strong analytical mindset shines in dissecting slow-running processes, while clear communication bridges gaps between technical teams and business stakeholders during incident reviews. Adaptability thrives in our fast-paced setting, where problem-solving under pressure maintains uptime for customer-facing apps. Collaborative spirit fosters knowledge-sharing in cross-functional stand-ups, and a detail-oriented approach upholds data governance standards unique to banking. Credit One Bank cultivates a vibrant culture in Las Vegas, blending high-energy innovation with work-life balance suited to the city's dynamic vibe. Our DBA team operates in collaborative pods, encouraging open forums for idea exchange amid modern office spaces with views of the Strip. Professional growth flourishes through internal tech symposiums and tuition reimbursement for advanced certs, positioning you for senior roles. Emphasis on employee wellness includes on-site fitness challenges inspired by local entertainment scene. The compensation package reflects our commitment to attracting top talent, featuring base salaries competitive within the Las Vegas market alongside performance-driven bonuses tied to system reliability metrics. Comprehensive health coverage encompasses medical, dental, and vision plans with low deductibles, plus a robust 401(k) match up to 6%. Generous PTO starts at 20 days annually, augmented by flexible scheduling for summer hours. Perks include tuition assistance, wellness stipends for gym memberships, and exclusive access to bank-sponsored events at premier Vegas venues.