Senior Database Engineer

Job Title: Senior Database Engineer 

Reports To: Manager, Database Administration 

Department: Cloud Platforms 

Location: Remote

Grade: 20 

Our Company: Priority Technology Holdings, Inc. is a leading financial technology company that specializes in providing integrated payments and banking solutions. Our innovative native platform empowers businesses to effortlessly collect, store, and send money in a scalable manner. We are committed to revolutionizing the way companies handle their financial transactions by offering cutting-edge 

technology and exceptional customer service. 

Job Summary: As a Database Engineer, your primary role involves analyzing and rewriting to enhance legacy code or database queries and procedures to improve database performance and query time per second. Able to work with the Application Development team to understand business needs and write advanced T-SQL functions and stored procedures. Assist in archiving, automation and query writing best practices. The Sr. Database Engineer reports to the Manager, Database Administration. 

Responsibilities: 

• Over 5+ years of professional experiences in writing SQL Scripts, including complex queries, views, triggers, functions and stored procedures. 

• Working cohesively with stakeholders including data, design, product and executive teams and assisting them with data-related technical issues. 

• Participate in code reviews to validate effectiveness and quality of code. 

• Develops, enhances, debugs, support, maintains and test complex query analysis and implementation that support multiple applications and business units. 

• Perform analysis, design, estimation and development of the database components. 

• Solid understanding of data integrity, primary keys, foreign keys and data consistency.

• Fundamental knowledge of query optimizer, query cache and index analysis for optimization efforts. 

• High critical thinking skills to assess alternatives and propose effective solutions. 

• Openness to discussions aligning with business objectives and strategies. 

• Expertise in Database Architecture in the environment that handles large volumes of data. 

• Deep understanding of RDBMS database architecture and multi platform knowledge as SQL Server and MySQL query patterns.

MINIMUM REQUIREMENTS: 

• BE or BS Degree in one of the following subject areas: Computer Science, Business Administration, Information Technology or related field 

• Preferred 5-10 years IT operation with strong understanding of database structures, theories, principles, and practices 

• Should be proficient in SQL Query Tuning and Slow Query Optimizations with rewrite in an optimized way. 

• Expertise in performance tuning especially tuning complex queries, procedure and index strategies. 

• Liaise with Developers to improve applications and establish best practices. 

• Implement processes and procedures for the development and release of products/projects and facilitate high quality and rapid deployments. 

• Follow agile development methodologies to deliver solutions and product features by following DevOps practices. 

• Good understanding of the organization’s goals and objectives 

• Good interpersonal, written, and oral communication skills 

• AWS Cloud experience is preferred with CLI and integration coding expertise to with on prem to cloud environment. 

• Ability to present ideas in user-friendly language. 

• Strong root cause analysis. 

• Self-motivated and directed, with keen attention to detail 

• Able to prioritize and execute tasks in a high-pressure environment 

• Experience working in a team-oriented, collaborative environment 

• Ability to work towards proactive solutions. 

• Experience using SQL Profiler and examining Execution Plans and query stores with slow query log analysis. 

• Required RDBMS knowledge of SQL Server 2012-20