Job Summary
The Database Architect / Database Administrator / Data Engineer is a senior technical role responsible for database architecture, administration, optimization, integration, and data engineering. The role will design and maintain scalable, secure, and highly available database solutions while developing and supporting enterprise data pipelines, integrations, data warehouses, data lakes, and reporting platforms. The position requires a balance of hands-on technical expertise, operational support, planning, data governance, and cross-functional collaboration.

Key Responsibilities
 Design and maintain enterprise database architectures supporting transactional, analytical, and operational systems
 Develop conceptual, logical, and physical data models based on business and technical requirements
 Establish database standards, architecture principles, governance frameworks, and data management best practices
 Design high-availability, disaster recovery, replication, and data resiliency solutions
 Administer Microsoft SQL Server and other enterprise database platforms
 Monitor database health, performance, capacity, and availability
 Perform database tuning, indexing, query optimization, and performance analysis
 Implement database backup, recovery, replication, and access controls
 Troubleshoot production database issues and perform root cause analysis
 Design, develop, and maintain organization-level data transformation and load processes and data pipelines
 Support data warehousing, data lake, and lakehouse architectures
 Develop data cleansing, transformation, validation, and reconciliation processes
 Support analytics, business intelligence, and reporting initiatives
 Automate data movement and operational support processes using modern engineering practices
 Adhere to enterprise data governance, metadata management, and master data management standards
 Ensure data quality, integrity, consistency, and lineage across systems
 Collaborate with cybersecurity and compliance teams to safeguard enterprise data assets
 Establish role-based access controls and database auditing standards
 Support regulatory, audit, SOX, and data retention requirements
 Partner with business stakeholders, application development teams, infrastructure teams, and contractors
 Document database administration activities, development environments, current projects, and operational tasks
 Facilitate database architecture reviews and technical design sessions
 Develop and maintain technical documentation, database standards, and operational procedures for current and future environments

Required Qualifications
 10+ years of experience in database administration or database design
 5+ years of experience supporting enterprise organizations or large-scale environments
 Demonstrated experience with enterprise data integration and analytics
 Advanced proficiency in Microsoft SQL Server
 Advanced SQL skills, including the ability to develop stored procedures
 Strong database architecture and data modeling expertise
 Deep understanding of relational databases and data integration patterns
 Experience writing SQL scripts for database development and administration
 Experience with data lakes, data warehouses, and data warehouse ETL
 Experience with SSIS and ETL development
 Experience with Power BI
 Experience with PowerShell and Python scripting
 Strong troubleshooting and analytical skills
 Strong understanding of data governance and cybersecurity principles
 Ability to lead technical initiatives and manage multiple priorities
 Strong verbal and written communication skills, with the ability to communicate technical concepts to technical audiences

Preferred Qualifications
 Experience with VBA
 Experience with T-SQL
 Experience with shell scripting
 Experience with lakehouse architectures
 Experience with database performance tuning
 Experience with disaster recovery and backup/recovery solutions
 Experience with database security and access controls
 Experience with capacity planning
 Experience with database automation and monitoring tools
 Experience supporting analytics, business intelligence, and reporting platforms