2+ Data warehouse architecture Jobs in Hyderabad | Data warehouse architecture Job openings in Hyderabad

Enterprise Data Architect - Dataeconomy (25+ Years Experience)

About Dataeconomy:

Dataeconomy is a rapidly growing company at the forefront of Information Technology. We are driven by data and committed to using it to make better decisions, improve our products, and deliver exceptional value to our customers.

Job Summary:

Dataeconomy seeks a seasoned and strategic Enterprise Data Architect to lead the company's data transformation journey. With 25+ years of experience in data architecture and leadership, you will be pivotal in shaping our data infrastructure, governance, and culture. You will leverage your extensive expertise to build a foundation for future growth and innovation, ensuring our data assets are aligned with business objectives and drive measurable value.

Responsibilities:

Strategic Vision and Leadership:

Lead the creation and execution of a long-term data strategy aligned with the company's overall vision and goals.

Champion a data-driven culture across the organization, fostering cross-functional collaboration and data literacy.

Advise senior leadership on strategic data initiatives and their impact on business performance.

Architecture and Modernization:

Evaluate and modernize the existing data architecture, recommending and implementing innovative solutions.

Design and implement a scalable data lake/warehouse architecture for future growth.

Advocate for and adopt cutting-edge data technologies and best practices.

ETL Tool Experience (8+ years):

Extensive experience in designing, developing, and implementing ETL (Extract, Transform, Load) processes using industry-standard tools such as Informatica PowerCenter, IBM DataStage, Microsoft SSIS, or open-source options like Apache Airflow.

Proven ability to build and maintain complex data pipelines that integrate data from diverse sources, transform it into usable formats, and load it into target systems.

Deep understanding of data quality and cleansing techniques to ensure the accuracy and consistency of data across the organization.

Data Governance and Quality:

Establish and enforce a comprehensive data governance framework ensuring data integrity, consistency, and security.

Develop and implement data quality standards and processes for continuous data improvement.

Oversee the implementation of master data management and data lineage initiatives.

Collaboration and Mentorship:

Mentor and guide data teams, including architects, engineers, and analysts, on data architecture principles and best practices.

Foster a collaborative environment where data insights are readily shared and acted upon across the organization.

Build strong relationships with business stakeholders to understand and translate their data needs into actionable solutions.

Qualifications:

Education: master’s degree in computer science, Information Systems, or related field; Ph.D. preferred.

Experience: 25+ years of experience in data architecture and design, with 10+ years in a leadership role.

Technical Skills:

Deep understanding of TOGAF, AWS, MDM, EDW, Hadoop ecosystem (MapReduce, Hive, HBase, Pig, Flume, Scoop), cloud data platforms (Azure Synapse, Google Big Query), modern data pipelines, streaming analytics, data governance frameworks.

Proficiency in programming languages (Java, Python, SQL), scripting languages (Bash, Python), data modelling tools (ER diagramming software), and BI tools.

Extensive expertise in ETL tools (Informatica PowerCenter, IBM DataStage, Microsoft SSIS, Apache Airflow)

Familiarity with emerging data technologies (AI/ML, blockchain), data security and compliance frameworks.

Soft Skills:

Outstanding communication, collaboration, and leadership skills.

Strategic thinking and problem-solving abilities with a focus on delivering impactful solutions.

Strong analytical and critical thinking skills.

Ability to influence and inspire teams to achieve goals.

Designation: Senior - DBA

Experience: 6-9 years

CTC: INR 17-20 LPA

Night Allowance: INR 800/Night

Location: Hyderabad,Hybrid

Notice Period: NA

Shift Timing : 6:30 pm to 3:30 am

Openings: 3

Roles and Responsibilities:

As a Senior Database Administrator is responsible for the physical design development

administration and optimization of properly engineered database systems to meet agreed

business and technical requirements.

The candidate will work as part of but not limited to the Onsite/Offsite DBA

group-Administration and management of databases in Dev Stage and Production

environments

Performance tuning of database schema stored procedures etc.

Providing technical input on the setup configuration of database servers and SAN disk

subsystem on all database servers.

Troubleshooting and handling all database related issues and tracking them through to

resolution.

Pro-active monitoring of databases both from a performance and capacity management

perspective.

Performing database maintenance activities such as backup/recovery rebuilding and

reorganizing indexes.

Ensuring that all database releases are properly assessed and measured from a

functionality and performance perspective.

Ensuring that all databases are up to date with the latest service packs patches &

security fixes.

Take ownership and ensure high quality timely delivery of projects on hand.

Collaborate with application/database developers quality assurance and

operations/support staff

Will help manage large high transaction rate SQL Server production

Eligibility:

Bachelors/Master Degree (BE/BTech/MCA/MTect/MS)

6 - 8 years of solid experience in SQL Server 2016/2019 Database administration and

maintenance on Azure and AWS cloud.

Experience handling and managing large SQL Server databases in a real time production

environment with sizes greater than 200+ GB

Experience in troubleshooting and resolving database integrity issues performance

issues blocking/deadlocking issues connectivity issues data replication issues etc.

Experience on Configuration Trouble shoot on SQL Server HA

Ability to detect and troubleshoot database related CPUmemoryI/Odisk space and other

resource contention issues.

Experience with database maintenance activities such as backup/recovery & capacity

monitoring/management and Azure Backup Services.

Experience with HA/Failover technologies such as Clustering SAN Replication Log

shipping & mirroring.

Experience collaborating with development teams on physical database design activities

and performance tuning.

Experience in managing and making software deployments/changes in real time

production environments.

Ability to work on multiple projects at one time with minimal supervision and ensure high

quality timely delivery.

Knowledge on tools like SQL Lite speed SQL Diagnostic Manager App Dynamics.

Strong understanding of Data Warehousing concepts and SQL server Architecture

Certified DBA Proficient in TSQL Proficient in the various Storage technologies such as

ASM SAN NAS RAID Multi patching

Strong analytical and problem solving skills Proactive independent and proven ability to

work under tight target and pressure

Experience working in a highly regulated environment such as a financial services

institutions

Expertise in SSIS SSRS

Skills:

SSIS

SSRS