Database Administrator/Engineer

Veritex Community Bank
United States, Texas, Dallas
Dec 20, 2024
Database Administrator/Engineer Dallas, TX, USA Req #272 Thursday, October 3, 2024 Job Summary: As a Database Administrator/Engineer, you will handle the development of all aspects of data processing, including database management, architecture/modeling, and ETL processing. Create and deliver analytical solutions using various tools. Collaborate with corporate data analytics team and business stakeholders to collect requirements and translate them into technical specifications and process documentation. Work on the architecture and development of an event-driven data warehouse, streaming, batch, data modeling, and storage. Provide technical guidance. Review code and test results. Review pulls requests and scripts for production development. Work on advanced databases, to write and optimize SQL queries, stored procedures, functions, partition data, indexing, and reading execution plans. Write and debug Python/PySpark scripts to generate extracts, clean, conform, and deliver data for consumption. Implement ETL architecture, data profiling, process flow, metric logic, and error handling. Support continuous improvement by exploring and presenting alternatives to processes and technologies. Responsibilities and Duties: Enable the design of conceptual architecture and technical solutions. Design, develop and maintain scalable and efficient data pipelines and workflows using Azure Synapse or like tools to support various business use cases and analytical requirements. Collaborate closely with cross-functional teams to understand data requirements and translate them into technical solutions. Implement and manage CI/CD pipelines using Azure DevOps to automate the deployment, testing and monitoring of data engineering solutions, ensure continuous integration and delivery. Optimize and tune data pipelines and process workflows for performance, scalability, and reliability. Collaborate with data architects, engineers, and analysts to design, develop, and maintain data pipelines and ETL processes. Leverage best practices and monitoring tools to identify and address bottlenecks and inefficiencies. Utilize Azure Data Studio to design and optimize database schemas, stored procedures, and SQL queries. Ensure best practices in data integrity, efficiency, and security. Monitor and troubleshoot data pipeline health and performance issues, proactively identifying and resolving issues to minimize downtime and ensure data quality and reliability. Create and maintain comprehensive documentation for data pipelines, workflows, and system configurations, ensuring knowledge transfer and compliance with organizational standards and policies. Conduct data profiling, cleansing and validation activities to ensure data quality and integrity throughout the data life cycle, adhering to data governance and compliance requirements. Participate in code review, testing, and debugging activities to ensure the reliability, stability, and maintainability of data engineering solutions. Provide technical guidance, mentorship, and support to team members. Troubleshoot and resolve data-related issues reported by end-users or detected through monitoring and alerting systems, ensuring timely resolution and minimal disruption to operations. Design and implement a mature data lifecycle, including backups and restore of data. Assist ServiceNow admins with creating workflows relevant to the data lifecycle. Ensure compliance with Role-Based Access and other regulatory requirements. Developing and implementing data governance policies and procedures to ensure data accuracy, completeness, and consistency. Ensuring data quality and integrity by implementing data validation, cleansing, and testing methods Troubleshooting and resolving data issues and providing technical support as needed 7 years or more experience required. Bachelor's degree required. Company Overview: Truth in Texas Banking. That's what we're about. Founded in 2010, we are one of the ten largest banks headquartered in the state of Texas. We became a publicly traded company in 2014 and in 2020 and 2021 we were listed on Fortune's 100 Fastest Growing Companies. Headquartered in Dallas, Texas, we've built a bank forever rooted in truth, transparency, and uncompromising integrity. We know our strongest asset is the passion, authenticity, and talent of our people. We focus on the growth and development of each team member to unlock potential to "Be Your True Self." Our "True You" culture is made up of five pillars: Be Mindful Be Healthy Be Better Be Prosperous Be Faithful With this as our foundation, we've built a bank of people who are transparent, tell the truth, and act with integrity. We unite together in common purpose - caring deeply for our clients and communities, communicating openly with each other, and treating everyone with respect. Visit our website at www.VeritexBank.com and come see how we're bringing truth and transparency to Texas banking. *Veritex Community Bank does not accept unsolicited resumes from recruiters or employment agencies.* Veritex Community Bank is under no obligation to pay any referral compensation or recruiter fee in the absence of a current executed Recruitment Services Agreement. In the event a recruiter or agency submits an unsolicited resume or candidate without an agreement, Veritex reserves the right to pursue and hire those candidate(s) without any financial obligation to the recruiter or agency. Any unsolicited resumes, including those submitted to hiring managers, shall be deemed the property of Veritex Community Bank. If your agency would like to be considered as a potential future recruiting partner, please leave your contact information at Recruiting@VeritexBank.com. Work environment and Physical demands: The employee may occasionally lift and/or move up to 25 pounds. The employee may occasionally stand, walk, reach, climb, balance, stoop, kneel, crouch, or crawl. The work environment and physical demands are those of a standard office setting. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of the job. Disclaimer: This job description is not an inclusive list of all duties and responsibilities of the position. Incumbents will be required to follow any other job- related instructions and to perform any other job-related duties requested by any person authorized to give instructions or assignments. Veritex Bank reserves the right to amend and change responsibilities to meet business and organizational needs. This document does not create an employment contract, implied or otherwise, other than an "at will" relationship. Veritex Community Bank is an equal opportunity employer. Veritex Community Bank Corporate Human Resources, Dallas, Texas. We are committed to a policy of Equal Employment Opportunity and will not discriminate against an applicant or employee on the basis of race, color, religion, creed, national origin or ancestry, sex, age, physical or mental disability, veteran or military status, genetic information, sexual orientation, marital status, or any other legally recognized protected basis under federal, state or local laws, regulations or ordinances. The information collected by this application is solely to determine suitability for employment, verify identity and maintain employment statistics on applicants. Applicants with disabilities may be entitled to reasonable accommodation under the terms of the Americans with Disabilities Act and certain state or local laws. A reasonable accommodation is a change in the way things are normally done which will ensure an equal employment opportunity without imposing undue hardship on the Company. Please inform the Company's personnel representative if you need assistance completing any forms or to otherwise participate in the application process. Other details Pay Type Salary Apply Now Dallas, TX, USA Share this job: