Architect Database & Data: Design databases like data landscapes

Starting at

$

40

/hr

About this service

Summary

Accountable for translating the business requirements into long-term information/data architecture solutions; developing methods of synchronizing data flow from multiple up streams and down streams

What's included

  • Professional Summary as an Architect

    • Expertise in Database Design, SQL Tuning, Storage Optimization, Cost Optimizer, Data Modelling, ETL, Indexing, Joins, Partitioning, Analytical Queries, Parallel Queries, Bulk operations, Managing & engineering Database, Data Compression, Data Cleaning, Integrity and Quality, Database Scaling, and Availability • Expert in Oracle SQL, PL/SQL, etc. for Oracle 19c,12c,11g,10g,9i, etc. • Proficient in MySQL 8, PostgreSQL 13, and orientation with NoSQL MongoDB etc. • Acquainted with public cloud infra like Azure for data engineering • Python 3 for Data engineering & some part of Web development with Django • Supported the Bank’s important, critical, multi-terabyte Databases and Data Warehousing platforms, Database migrations and Database cost optimization programs, and automation of database deployments and release processes • Defining and maintaining best practice guidelines and standards for data, metadata, Data Modeling, and management and best practices that support the firm’s data governance program • Oversee the firm’s data governance maturity model and encourage data stewards to take the steps necessary to adhere to guidelines provided for data management, data quality and overall data stewardship • Built, maintained, and managed scalable OLTP, OLAP, Analytical and Reporting data platforms, and Data-Driven Business applications • Strong people management skills; mentoring techies as Database SME, Active in effective Recruitment-drives • Have successfully led and managed deliveries of critical importance, having stringent timelines and dynamic requirements in highly agile development environments. • Proficiency in debugging, diagnosing, and code fixing for performance issues in data-centric operations within established protocols, guidelines, standards & Documenting • Evaluation for the enhancements with a Feasibility Study, Proof of concept & prototype • Knowledge of the Incident, Problem, and Change Management processes within the Service Now framework • Experience in all phases of SDLC for waterfall and agile methodologies. Agile tools like JIRA, Confluence, and version controlling using GitHub, Etc.


Skills and tools

Database Engineer
Data Engineer
Database Specialist
MySQL
Oracle Database
PostgreSQL

Industries

Information Technology

Work with me