Location: Coppell, TX
Company: Lanvera
including print, electronic and mobile platforms.
Lanvera has a strong presence in the Financial Services industry and is expanding into other vertical markets. THE POSITION: Seeking an experienced SQL DBA with expertise in T-SQL development, troubleshooting and optimization.
The Senior SQL DBA will manage Microsoft SQL Server databases, services, and tools running in an on-prem environment as well as participate in building a database presence in the cloud (hybrid solution). In this role you will maintain database uptime, stability, performance, and security to ensure the highest customer service levels. You will also leverage your passion for data engineering to design, develop,
and implement ETL solutions, involving close collaboration with development and business intelligence stakeholders. RESPONSIBILITIES: Review, analyze and debug T-SQL code Optimize data workloads across cloud and/or on-prem environments to stay ahead of business demand while minimizing costs Develop complex SQL scripts, functions and stored procedures Participate in architecture planning to prepare the business for significant future growth Manage production database servers to ensure robust security, high availability and performance Actively monitor databases and take preventive or corrective action to swiftly resolve issues that arise Support and enhance db's running on Azure Managed SQL Instance(s)
Implement policies and procedures for database backups, DR, security protocols, and data integrity Maintain lower-level development, QA, and staging database environments to support efficient development throughout the SDLC Create comprehensive diagrams and documentation that accurately captures database state Support development groups with database setup, configuration, optimization, and other modifications Bring a passion to stay current on industry database trends and related technology Adept at collaborating with leadership and technical stakeholders throughout the organization Adhere closely to change control and related ITIL practices Work in a highly collaborative software development environment that is primarily onsite ADDITIONAL RESPONSIBILITIES: Provide best practice guidance on the design of data models and database structures across relational database platforms Assist in development, support, and implementation of data engineering projects such as data pipelines and warehouses Assist in development of methods to manipulate large, complex data sets to be effectively consumed and interpreted within reporting toolsets REQUIRED SKILLS: Bachelor's Degree in Computer Science or commensurate experience 5+ years' experience supporting SQL Server databases in production environments that utilize Always On Availability Groups and Windows Clustering 5+ years' experience in writing complex T-SQL to develop a variety of database objects (schemas, tables, stored procedures, triggers) 4+ years' experience in database tuning and query optimization through analysis of Execution Plans and Dynamic Management Views, and usage of Extended Events 3+ years' experience with developing packages within SQL Server Integration Services (SSIS) 2+ years' experience with developing reports within Power BI and/or SQL Server Reporting Services (SSRS) DESIRED SKILLS: Experience with Windows and Linux Server administration Familiarity with automating processes using Powershell or similar scripting language COMPANY BENEFITS: Lanvera offers excellent benefits including three weeks of PTO, Health Insurance, 401K with dollar matching, profit sharing, and long-term disability.
IT jobs refer to employment within the field of information technology, an industry centered on the creation, maintenance, and support of computer systems and networks. Characteristically, these roles demand technical expertise in areas such as software development, cybersecurity, and data analysis. IT professionals are typically required to quickly adapt to new technologies and solve complex problems, often working in dynamic, fast-paced environments. The sector is known for its diverse career opportunities and has become essential across virtually all business sectors, reflecting the critical role technology plays in modern society.
IT jobs refer to positions focused on the development, implementation, support, and management of computer-based information systems. These roles often require skills in programming, system analysis, hardware and networking, database management, and cybersecurity. Characteristic features of IT jobs include a strong emphasis on problem-solving, continual learning to keep up with rapid technology changes, and the potential for remote work given the digital nature of the field. IT professionals might work in various industries, from tech corporations to financial services, health care, and government sectors.
IT jobs refer to positions within the Information Technology sector, which encompasses a broad range of roles focused on the development, implementation, and maintenance of technology systems. These positions often require skills in programming, network administration, cybersecurity, and data analysis. IT professionals work with computer hardware, software applications, and algorithms. Key characteristics of IT jobs include a focus on problem-solving, continuous learning to keep up with technological advancements, and the ability to adapt to the evolving digital landscape. Many IT roles also support remote work, given the digital nature of the tasks.
to meaningful real-world projects which will be implemented during your internship. In addition to tackling practical business and technical problems, you will have access to a variety of mentors and senior leaders within the team. KEY RESPONSIBILITIES: Support the IT/Development team in maintaining systems, software, and limited hardware.
Create Power BI dashboards to optimize business decisions through the use of enhanced business analytics. Participate in Sagent's company-wide " digitalization" effort. Participate in DLL modification and documentation projects. Support IT/Development team in areas such as cybersecurity, programming, analytics, data center management, and
resource accountability Other duties as assigned by appropriate Sagent leadership. SKILLS/KNOWLEDGE/EXPERIENCE REQUIRED: Must be pursuing a degree in Computer Science (with AI), Computer Engineering, and Business Computer Information Systems Minimum GPA of a 3.0 Familiar with AI, Python, C#, C++, SQL,Net, etc.
Knowledge of Microsoft Stack (Power BI) Strong verbal and written communication Excellent analytical and problem-solving skills Ability to work well in teams. Strong work ethic and attention to detail Energetic, self-motivated interpersonal skills and communication skills with the ability to interact with various management levels. PHYSICAL DEMANDS WORK ENVIRONMENT: The physical
demands and work environment described here are representative of those that must be met by an employee to successfully perform the essential functions of this position.
Reasonable accommodation may be made to enable individuals with disabilities to perform the functions. Environment: Fully on-site role in a standard office setting with exposure to computer screens. Physical: Primary functions require sufficient physical ability to work in an office setting; stand or sit for prolonged periods of time; operate office equipment including extensive use of a computer keyboard. Vision: See in the normal visual range with or without correction; vision sufficient to read computer screens and printed documents.
Hearing: Hear in the normal audio range with or without correction.
