Job Information
Aspira Connect Database Engineer in United States
Position Purpose and Impact
- Holding a critical role in our Company, our Database Engineer III encompasses the planning, design, development, and management of application databases across various environments, from R&D to production. Working both independently and collaboratively within a dynamic team setting, incumbent supports software engineering, Technical Account Management, and Client Implementation teams with a wide array of database-related activities. These tasks range from crafting database update scripts for application configuration to preparing test environment databases and facilitating client data import and migration processes. By ensuring the seamless operation of our database infrastructure, the Database Engineer enables efficient collaboration across teams and contributes significantly to the successful delivery of our software solutions.
Responsibilities
Design, write, and thoroughly test queries, stored procedures, and functions to deploy database updates required by the Aspira-developed applications.
Design and implement database release management and automation processes for application-related database updates.
Develop and maintain data models, schemas, and data dictionaries.
Optimize database performance through indexing, query optimization, and other tuning techniques.
Collaborate with development teams to design efficient database schemas and implement data access layers.
Provide guidance to software engineers on best practices for database schema and script design.
Evaluate, organize, transform, and import external data as required.
Review and approve application-related database updates.
Monitor database performance and health, identify opportunities for optimization, and implement proactive measures to ensure system stability and reliability.
Perform database backups, restores, and disaster recovery procedures.
Troubleshoot and resolve database issues, including performance bottlenecks, connectivity problems, and data corruption.
Implement and maintain database security measures, including access controls, encryption, and data masking.
Stay current with database technologies and best practices and make recommendations for improvements to our database systems and processes.
Champion Aspira policies and procedures, uphold product quality and reputation, and consistently adhere to compliance and relevant initiatives by preserving the confidentiality of information, safeguarding organizational assets, and acting with integrity and ethics.
Support the Solutions division by actively participating in pertinent projects and fulfilling other assigned duties.
Desired Qualifications
Proficiency in SQL and PL/SQL development, demonstrating superior skills in writing efficient queries, stored procedures, and functions.
Extensive knowledge and experience in database release and deployment automation, ensuring smooth and efficient database updates and deployments.
Advanced expertise in monitoring and tuning database performance to optimize system efficiency and responsiveness.
Proven track record as a proactive and hardworking team player, capable of thriving in a dynamic and collaborative work environment.
Strong troubleshooting and problem-solving abilities, with a proactive approach to identifying and resolving database-related issues.
Solid software development skills, complementing database expertise to effectively collaborate with development teams on database-centric aspects of software projects.
Desired Education and Experience
Bachelor’s degree in Computer Science, Computer Engineering, Information Technology, or a related discipline.
Minimum 4 years’ experience within a Database Engineer, Database Administrator, or Site Reliability Engineer position within a software/application development organization.
Collaborative experience with software engineering teams with experience improving application performance through efficient database schema design.
Expertise in database security implementation with exposure to reducing security vulnerabilities and compliance issues through effective access controls and encryption.
Exposure to the Outdoors Recreation or Outdoors Hospitality industry benefits.
Desired Hardware and Software Competency
Demonstrated experience with the Oracle database management system and related tools (e.g., GoldenGate)
Experience with solutions such as Liquibase or Redgate.
Practical knowledge of data management tools and platforms (e.g., CloverDX).
Practical knowledge of other database management systems including NoSQL (e.g., PostgreSQL, DynamoDB, etc.).
Hands-on experience with Amazon Web Services (AWS).
Practical knowledge of Linux – Amazon Linux, CentOS, or a similar distribution.
Hands-on experience developing software in Java, C#, Python, or a similar language.
General Physical Demands
The below physical demands are representative of those that must be met 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 including printers, or fax machines.
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. A mobility ability to move within an office setting as well as depart and return to a workstation punctually for assigned breaks or meal periods is required.