Senior Database Administrator / Database Architect / Data Engineer

Position overview 

Con Edison is seeking a Senior Database Administrator to support enterprise database architecture, administration, optimization, integration, governance, analytics, and data engineering initiatives. The role combines hands-on SQL Server administration with data warehousing, ETL, data pipelines, reporting, security, and enterprise data-management responsibilities. 

Responsibilities 

• Design and maintain enterprise database architectures for transactional, analytical, and operational systems. 
• Develop conceptual, logical, and physical data models. 
• Administer Microsoft SQL Server and other enterprise database platforms. Monitor database health, performance, capacity, availability, and utilization. Perform query optimization, indexing, performance tuning, and root-cause analysis. 
• Implement backup, recovery, replication, high availability, disaster recovery, and access controls. 
• Design, develop, and maintain ETL processes and enterprise data pipelines. 
• Support data warehouses, data lakes, lakehouse environments, analytics, and reporting platforms. 
• Develop data cleansing, transformation, validation, reconciliation, and quality processes. Support Power BI and business-intelligence initiatives. 
• Apply data governance, metadata, lineage, master-data, security, audit, SOX, and retention practices. 
• Establish role-based access controls and database auditing standards. 
• Collaborate with cybersecurity, infrastructure, application-development, business, and contractor teams. 
• Facilitate architecture reviews and technical design sessions. 
• Maintain technical documentation, standards, procedures, and operational guides.