Lead Database Engineer

Lead Database Engineer

Job Description:

The Information Technology Software Engineer oversees application development, modification, and maintenance of applications. This position monitors system applications, ensures systems run smoothly, and creates reports and other documentation outlining findings/solutions.

Primary Responsibilities

• Oversees development and installation of new hardware and software


• Provides advice and recommendations to management on processes and techniques required for improved work operations


• Installs and configures systems and other software


• Tests installed software for malfunction detection


• Identifies and resolves business systems issues


• Designs and deploys new applications and enhancements to existing applications, software, and operation systems


• Measure's effectiveness and efficiency of existing systems


• Develops and implements strategies to improve systems


• Monitors and tests system performance


• Oversees the training of junior engineers to improve job skills and work efficiency


• Typically has full ownership of a process


• May act as a procedural expert

This position is exempt from timekeeping requirements under the Fair Labor Standards Act and is not eligible for overtime pay.

Requirements

• Bachelor's degree in Computer Science, Computer Engineering, or a related field


• Five (5) years of experience

Skills and Competencies

• Ability to collaborate with programmers, developers, and other technology professionals to achieve a common objective


• Ability to conduct system analysis to detect issues with performance


• Ability to develop and implement technology solutions to resolve technical challenges


• Knowledge of software testing techniques, code optimization and software debugging


• Strong communication, analytical and problem-solving skills


• Strong executional capabilities


• Thorough understanding of software structures, hardware, computing systems and how to integrate them


• Looking for an Engineer who likes to build/integrate applications, high volumes services that handle volumes of data to detect and manage financial crimes using cutting edge technologies.


• Providing support, guidance and collaborating with Application Developers to implement database design, and review developer's work to ensure correct implementation.


• Develop stored procedures, functions, packages, triggers and views using SQL and Assist with schema design, code review and SQL query tuning.


• Develop ETL processes, SSIS packages and SSRS reporting for data extracts/analysis and ad hoc reporting.


• Develop ETL processing using PySpark on a Cloudera Hadoop cluster.


• Maintain development and monitoring tools in Python for the ETL process.


• Maintain Data integrity tests in Python and SQL.


• Participate in deployment activities by developing and using CI/CD pipeline


• Work as part of an Agile development team to solve problems and develop projects in a fast-paced environment.

Skillsets/Experience

• Proficient in Hadoop/Hive


• Strong knowledge in ETL capabilities


• Proficient in Python, Pyspark,


• Experience with DevOps tools (GitHub, Bamboo, UCD, etc.)

Good to have

• Programming languages such a C# or Java is a plus


• Monitoring tools such as Orion and Splunk


• Power BI reporting


• Familiarity with Python Flask will be a plus


• Experience in SQL Server is a plus

THIRD PARTY AGENCIES, SUBCONTRACTORS, AND RECRUITERS NEED NOT APPLY. Applicants received from firms will not be considered. Subcontracting is not available for this position.