Sr. Database Administrator

Note:

• In-person Interview
• Please prioritize stronger candidates with experience at reputable clients. Utility or Energy sector Industry will be amazing but not a must!!

TECHNICAL SKILLS Must Have

• Ability to write scripts in SQL
• Advanced proficiency in SQL, including stored procedures
• Data Lakes
• Data Warehouse
• Data Warehouse ETL
• Powerbi
• PowerShell
• Python
• SSIS

JOB DESCRIPTION
The Database Architect / Database Administrator / Data Engineer is a senior technical role responsible for the design, administration, optimization, integration, and governance of Construction organization's data.
This hybrid position combines database architecture, database administration, and data engineering functions to support critical business applications, analytics, initiatives, and digital transformation programs.

The successful candidate will lead the scalable, secure, and highly available database solutions while developing and supporting enterprise data pipelines, integrations, and reporting platforms.
The role requires a balance of planning, hands-on technical expertise, operational support, and cross-functional collaboration across many stakeholders.

Key Responsibilities
Database Architecture

• Design and maintain enterprise database architectures supporting transactional, analytical, and operational systems.
• Develop conceptual, logical, and physical data models to support 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.

Database Administration

• Administer SQL Server and other enterprise database platforms.
• Monitor database health, performance, capacity, and availability.
• Perform database tuning, indexing, query optimization, and performance analysis.
• Implement backup, recovery, replication, and access controls.
• Troubleshoot production issues and perform root cause analysis.

Data Engineering

• Design, develop, and maintain organization level transform and load processes and data pipelines.
• Support data warehousing, data lake, and lakehouse architectures.
• Develop data cleansing, transformation, validation, and reconciliation processes.
• Support the team performing analytics, business intelligence, and reporting initiatives.
• Automate data movement and operational support processes using modern engineering practices.

Data Governance & Security

• Adhere to data governance standards, metadata management, and master data management practices as dictated by enterprise 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 auditing standards.
• Support regulatory, audit, SOX, and data retention teams.

Leadership & Collaboration

• Partner with business stakeholders, application development teams, infrastructure teams, and contractors.
• Documenting database administration, development environments, and current projects and tasks.
• Facilitate database architecture reviews and technical design sessions.
• Develop and maintain technical documentation, standards, and operational procedures for current and future environments.

Qualifications
Education

• High School, associate's Degree, bachelor's degree or Equivalent combination of education and experience will be considered.

Experience

• 10+ years of experience in database administration or database design.
• 5+ years supporting enterprise organizations/ large scale companies.
• Demonstrated experience in enterprise data integration and analytics.

Technical Skills
Database Platforms- Required

• Microsoft SQL Server

Development & Scripting Preferred experience

• VBA
• SQL
• T-SQL
• Python
• PowerShell
• Shell Scripting

Data Engineering & Analytics Preferred experience

• SSIS
• Data Lakes
• Data Warehousing
• ETL (Transform and Load) Development
• Power BI

Infrastructure & Operations Preferred experience

• Performance Tuning
• Disaster Recovery
• Backup and Recovery
• Database Security
• Capacity Planning
• Automation and Monitoring Tools

Knowledge, Skills, and Abilities preferred experience

• Strong database architecture and data modeling expertise.
• Deep understanding of relational databases and data integration patterns.
• Excellent 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.
• Ability to communicate technical concepts to technical audiences.

Working Conditions

• Hybrid work arrangement with a combination of onsite and remote work.
• Participation in planned maintenance windows and occasional after-hours support.
• Availability for on-call support during critical production incidents.
• This is a Contract position.