Architect Database & Data: Design databases like data landscapes
Vikram Sheth
Starting at
$
40
/hrAbout this service
Summary
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
Industries
Work with me