Posted in

Database Developer Tech Lead

Database Developer Tech Lead

CompanyHolman
LocationToms River, NJ, USA
Salary$97450 – $141300
TypeFull-Time
DegreesBachelor’s
Experience LevelSenior

Requirements

  • Bachelor’s degree in a related field or equivalent work experience
  • Proficient in various desktop tools including MS Office Programs (i.e. Outlook, Excel, Word, PowerPoint, Project, Visio, SharePoint etc.)
  • Azure AZ900, DP900, DP-300 training required
  • Minimum 5 years tenure as a Database Administrator Experienced with relational architecture and Data Warehouse
  • Minimum 3 years’ experience with installing, configuring, and supporting Oracle and/or SQL server database environments
  • Experience with Azure SQL database environments
  • Understanding of Azure ecosystem and database services like Azure Blob Storage, Azure Data Lake, Azure Key Vault, etc.
  • Must be well versed with database procedures to include: installation, configuration, backup and recovery, performance tuning, and SQL statement tuning
  • Experience using ETL tools to document and move data as needed
  • Experienced with Linux operating system and shell scripting
  • Experienced with Windows Server operating systems

Responsibilities

  • Provide technical guidance and mentorship to the database development team
  • Design, develop, and optimize database systems to meet business requirements
  • Recommends improvements to the database architecture and design to enhance scalability, availability, and security
  • Collaborates with the DevOps team to automate database deployments and integrate with CI/CD pipelines
  • Create and maintain comprehensive documentation for database systems and processes
  • Stay updated with the latest database technologies and best practices, and implement improvements as needed
  • Monitor and optimize database performance, ensuring high availability and reliability
  • Work closely with software developers, business analysts, and other stakeholders to integrate database solutions with applications
  • Perform code reviews to support Database development
  • Perform database deployments
  • Optimize database queries and stored procedures for maximum efficiency and performance
  • Develops complex SQL queries, stored procedures, functions, triggers, and views to support business logic and application functionality
  • Performs data modeling, including designing schemas, tables, indexes, and relationships, for both transactional and analytical use cases
  • Provides support for troubleshooting and resolving database-related issues reported by application teams
  • Works closely with application developers to integrate database systems with applications and ensure efficient data flow
  • Configures and manages Azure Databases, including automated backups, replication, and high-availability options
  • Implements and manages database security, including encryption, access controls, and auditing, to meet industry standards and regulatory requirements
  • Ensures disaster recovery strategies are in place, including point-in-time restore and geo-replication for Azure SQL Database
  • Stays current with Azure database services and industry trends, incorporating new features and best practices as appropriate
  • Provides off-hours support when required
  • Provides on-site disaster recovery assistance when required
  • Perform all other duties and special projects as assigned

Preferred Qualifications

  • Additional education, certifications, or other distinctions are a plus
  • Azure certifications such as Microsoft Certified: Azure Database Administrator Associate or Azure Solutions Architect Expert are highly preferred