Database Architect Resume Irving, TX - Hire IT People

SUMMARY:

Experienced data professional in multi cloud service providers - AWS, GCP and Azure
A trusted advisor, leader, partner and solutions provider to critical applications
Partnered wif senior stakeholders including direct report/communication wif CxOs
Strong Hands-on experience on Architecture, Design, Development, Scalability and Maintenance wif near-zero downtime
Design and Architect Entity-Relationships on both OLTP and BI environments.
Strong passion for excellent automation, client delivery, complex problem solving and optimizing process
Strategic leader wif wealth of experience in augmenting innovative solutions and out of box thinking strategies.
Technology enabler wif expert knowledge in cloud spend, driving increase in revenue and cost efficiency.

TECHNICAL SKILLS:

Cloud Computing: AWS, Azure, GCP, IaaS, PaaS, SaaS, Serverless architecture

Databases (Relational/NOSQL): SQL Server, PostgreSQL, Oracle, MySQL, MongoDB

Tools: / Tech Windows, Linux, TSQL, PowerShell, Big Data, ServiceNow, Visio, Python, JSON

Methodologies: Agile, Waterfall

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Database Architect

Responsibilities:

Rearchitect and deploy the current financial Datawarehouse and ETL processes using SQL Server on Azure to achieve 500% process improvement across multiple database systems to halp COGNOS users wif the ability to make near real time decisions.
Database and process optimization which resulted in 8X faster reports for senior management
Provide guidance and direction on projects ensuring overall fit wif architecture direction
Educate partner companies and staff on technology changes, deployments and overall strategy
Leading the effort to migrate current cloud IaaS environment to a more serverless cloud based Datawarehouse using Azure Synapse
Provide expertise and guidance on an as-needed basis for current production Datawarehouse SQL Servers

Confidential, NYC, NY

Database Specialist and Architect

Responsibilities:

Data modeling, ELT of Bigdata and optimization of data loads using data lake and Google Big query
Migration of on-premise database servers to Google cloud platform (GCP) for multiple use cases using SQL Server always-On, storage pools using Microsoft Storage spaces direct and Cloud SQL
Collaborate wif application, infrastructure team and senior leadership to gather application requirements and challenges wif the modernization strategy to understand performance needs and cost for database migration and optimization
Evaluate, assess and compare server performance wif licenses and cost on both Google cloud wif on premise infrastructure to arrive at the optimal instance type and configuration

Confidential, Irving, TX

Infrastructure Solutions Architect / Database Architect

Responsibilities:

Architect, design and maintain high performance large systems for ICG clients wif HA/DR technologies and provided guidance and support to team of junior DBAs to halp wif BAU activities
Develop a tactical plan, provision hardware, and migrate over 60 terabytes to increase resiliency (by moving the data to an active-active cluster) and reduce total cost of ownership. Project generated 4MM cost savings per annum.
Design and oversee the implementation of OLTP and BI database schema, security and data governance compliance for commercial credit card management system, which was replicated for 5,000+ databases, for the Co-Branded Card (e.g., Costco Citi Credit Card) line of business.
Design a module to replicate databases (log shipping module) dat handled 50X the load of the native solution (100 database vs. 5,000 databases). The module, which became Citi’s organization wide standard for log shipping, was capable of synchronizing databases across disconnected datacenters.
Won numerous performance s wif a lot of client recognition
Led efforts to increase scalability for CCAR, a system dat generates Confidential ’s WW quarterly earnings report, and fine-tuned database performance to improve the turnaround time of the critical system by 83% in 2016.