s.
Job Description
ESSENTIAL JOB DUTIES/RESPONSIBILITIES:
- Active in all phases of system development; planning and analysis, design, development, and
testing.
- Provides architectural/database technical expertise to team concerning methods, procedures,
and standards to be used during design and development phases.
- Maintains application performance and scalability; focus on performance tuning SQL queries,
table design, indexing, query plan analysis and SQL refactoring.
- Develops and maintains technical documentation and operational procedures for areas of
responsibility.
- Investigates and fixes defects; pre and post-release.
- Worked with DDL/DML auditing (3rd party or native tools).
- Implements and maintains at rest or in-transit database encryption methodologies based of
- HIPAA requirements/needs.
- Prepares and deploys complex schema updates, data migration and ETL scripts.
- Follows and contributes to team standards and utilizes industry best practices.
- Works closely with the DBA to help ensure the proper health of the database system.
Other responsibilities may include:
- Helps develop new database code, and improve existing database code.
- Automates operational / maintenance tasks.
- Identifies useful and new database features; discusses with the existing database team and
- implements them.
- Assists Engineers on efficient use of database technologies and features.
- Takes code ownership of areas like loading data from external systems through SSIS,
- Procedural Logic, and understanding of core relational concepts.
- Modularizes database features.
- Assists in performance tuning and make optimization suggestions to the team.
- Takes part in code reviews and offers up solutions to problems, with reasoning to back up the
- proposed solution.
- Other duties as assigned and modified at manager’s discretion.