What are the responsibilities and job description for the Senior Database Engineer position at Aspira Connect?
Position Purpose and Impact
The Senior Database Engineer role is pivotal in architecting, building, and maintaining scalable data systems that underpin our business. The ideal candidate will have a deep understanding of data architecture, database systems, and be proficient in SQL and Liquibase for managing database schemas and data migrations.
Responsibilities
Utilize SQL to manage, optimize, and query large datasets. Handle schema evolution using Liquibase for version control of database changes.
Optimize SQL queries and database performance for speed and efficiency.
Automate database change management using Liquibase, or other change management software.
Design, build, and maintain robust data pipelines to move, process, and store data efficiently.
Ensure high data quality through the implementation of rigorous validation and monitoring systems.
Understands data pipelines and migrations and can consult with the team for high performing data analysis.
Ensure the timely delivery of high-quality outcomes, consistently meeting or exceeding expectations.
Strategically overhauls teams and systems to modernize, build faster, build more efficiently; Manages hardware strategy.
Cultivate a culture of continuous improvement and adaptability to support ongoing transformation efforts.
Communicate regularly with management and other key stakeholders to provide updates on initiatives, progress, and outcomes.
Identify and mitigate risks related to technology, security, compliance, and regulatory requirements.
Implement effective knowledge sharing and documentation practices, ensuring transfer of institutional knowledge and reducing reliance on individual experts.
Promotes Company and Solutions business policies and procedures, the quality of its products and reputation, and consistently supports compliance by maintaining the privacy and confidentiality of information, protecting the assets of the organization, and acting with ethics and integrity.
Desired Qualifications
Strong ability to understand business processes and find ways to automate them using SQL.
Extensive experience with leading databases like Oracle and SQL Server, along with hands-on exposure to DynamoDB and Snowflake.
Advanced proficiency in SQL, PL / SQL with experience in complex query design, optimization, and database administration.
Extensive experience with Liquibase or similar tools for database schema migration and version control.
Familiarity with ETL tools like DBT, Oracle Golden Gate, and Fivetran is a big plus.
Knowledge of big data technologies (e.g., Hadoop, Spark) and cloud platforms (AWS, Azure, GCP) is highly advantageous.
Experience with programming languages like Python or Java for data manipulation.
Deep understanding of software engineering principles, modern development methodologies, and cloud-based technologies.
Excellent communication and interpersonal skills, with the ability to effectively collaborate with cross-functional teams.
Desired Education and Experience
Bachelor’s degree in computer science or related discipline.
Demonstrated proficiency with rapid programming, agile development, software patterning, and refactoring techniques.
Experience working in medium to large-sized teams.
Familiarity with the PCI regulatory framework.
Desired Hardware and Software Competency
Competence in database management systems (DBMS) and SQL.
Microsoft Suites Intermediate Level : professional usage of suites in an office setting
General Physical Demands
The below physical demands are representative of those required to successfully perform the essential functions of this job.
Visual Acuity : Close visual acuity to read and analyze data on a computer monitor.
Hearing Ability : Must be able to communicate effectively in person, over the phone, and through electronic media.
Manual Dexterity : Operation of a phone, keyboard, mouse, and general office equipment.
Repetitive Motion : Regular and consistent use of hands and fingers for typing, writing, and other computer-related tasks.
Lifting and Carrying : Occasional lifting and carrying of office supplies and materials weighing up to 10 pounds.
Sedentary Work and Body Position : The majority of work is performed while stationary or sitting at a desk or computer workstation. Prolonged periods of sitting and working on a computer are required. The ability to maintain the required body positions for extended periods, including sitting and using a computer is required. The ability to move within an office setting as well as departing and returning to a workstation punctually for assigned breaks periods is required.
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
What is the career path for a Senior Database Engineer?
Sign up to receive alerts about other jobs on the Senior Database Engineer career path by checking the boxes next to the positions that interest you.
