[Sr. SQL Server DBA[ - Corecard Software, Inc. - Norcross, GA.

**[Job Duties[: Responsible for the implementation, configuration, maintenance, and performance of highly transactional mission critical OLTP systems to ensure the availability and consistent performance of hosted applications. Manage SQL Server databases through multiple product lifecycle environments from development to mission-critical production systems. Configure and maintain database servers and processes including monitoring system health and performance, to ensure high levels of performance, availability, and security. Support day to day operational activities for the database platform including service requests and tickets, monitoring, and troubleshooting performance issues. Support Microsoft Windows 2016 and 2019 Enterprise Servers that support the SQL application, including configuration and maintenance. Implement and supports high availability solutions for MS SQL including Always-On. Monitor Microsoft SQL Server activity on a proactive basis and tune the system for optimal performance. Provide guidance and support to Application Developers, identifying most resource-intensive queries on the server and suggesting ways to improve performance on each. Analyze/design indexes for existing applications, proactively monitor query performance, and provide analysis when to add or remove indexes. Investigate, analyze, and troubleshoot system performance and suggest/implement tuning as needed. Develop system tools and utilities (e.g. scripts, etc.) to simplify and support business operations. Document and improve upon processes, procedures, and best practices to align with fintech industry standards and customer needs. Provide a high-level of customer satisfaction for internal and external customers, applying necessary sense of urgency and creativity in problem identification and prompt incident resolution. Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end. Determine the most effective way to increase performance, server configuration changes, or index/query changes. Assist developers with complex query tuning and schema refinement. Troubleshoot SQL Server service outages as they occur, including providing support during after-hours and weekends. After-hours work may also include, but not limited to scheduled maintenance, supporting application deployment, and hardware/software upgrades. Plan and schedule the installation and configuration of new SQL Servers. Analyze the requirements for new projects and determine whether to use failover clustering, log shipping, always-on, or other technologies to solve a business problem. Share expertise with team members providing technical mentorship and cross-training as needed.

**[Minimum Requirements[: Bachelors degree (or foreign degree equivalent) in Computer Science, Computer Applications, or a related field. Must have 5 years of experience in MS SQL Server Administration, including demonstrated experience in: database models and styles (OLTP, OLAP, NoSQL); Database Design, Development and Administration of MS SQL Server 2016+ in Production, QA, and Development environments; Installation and configuration of SQL Server in standalone and high availability environments; deployment, configuration, and maintenance of SQL Always-On; configuration management concepts; release management; change management concepts; industry standards and best practices; security concepts and vulnerability management related to SQL Server; database tasks including backup and restore by using SQL Server native tools and third-party software; complex stored procedures, triggers, functions, views, constraints, and indexes; Performance Tuning and Optimization; native monitoring and troubleshooting tools such as enterprise manager, query plans, performance views, trace files, etc.; and Windows server including Active Directory.

[Must have legal authority to work in the U.S. EEOE.

[How to Apply: [Send resumes to Rebecca Cox, CoreCard Software, Inc., 1 Meca Way, Norcross, GA 30093, or email to rebecca@corecard.com. Please reference job title + HM24 in cover letter or email subject line. ]{arial",sans-serif"=""}]{arial",sans-serif"=""}]{arial",sans-serif"=""}]{arial",sans-serif"=""}]{arial",sans-serif"=""}]{arial",sans-serif"=""}]{arial",sans-serif"=""}]{arial",sans-serif"=""}]{arial",sans-serif"=""}