Database Administrator/Data Architect Resume

TECHNICAL SKILLS

Programming: TSQL, PSQL, PL/SQL, Oracle, SSIS/SSRS/SSAS, PowerShell, XML, Java Script, .NET, C, C++, C#, JSON, AWS Lambda/CLI, Pathon, PySpark/Spark, HIVE

Application/Service: SQL Server 2017/2016/2014/2012/2008 R2/2008/2005, Azure, AWS (EC2, RDS, S3, EMR, Redshift, Aurora, DMS, Glue, Athena, Kinesis, Data Lakes), MySQL, PostgreSQL, NoSQL(MongoDB, DynamoDB, Elastic Search ), ER - Studio, Toad, Visio, JIRA, TFS, ServiceNow, Salesforce, PowerBI, Tableau, QuikSite, Snowflakes, MuleSoft, Informatica, Talend, IBM Infosphere, VMware, vSphere

DBA Tool: Idera, Redgate, Solarwinds, Extrahops, MS PAL, Ignite, LiteSpeed, commVault, sCOM, DoubleTakes, Nagios, PssDiag, Cloudera, CloudCraft, CloudBerry, CloudWatch, SNS

PROFESSIONAL EXPERIENCE

Database Administrator/Data Architect

Confidential

Responsibilities:

Provide technical leadership to ensure high availability, security, stability and scalability of OLTP/ OLAP database systems & accuracy and consistency of data on premises & cloud platforms;
Make architectural decisions to optimize database/pipeline performance and minimize infrastructure cost;
Advise security solutions to protect/encrypt data in - transit & at-rest and ensure compliance with HIPAA & industry regulations;
Provide technical leadership in build/maintain HA/DR database solutions across datacenters & cloud per RPO, RTO & SLAs;
Lead to develop backup recovery & BCP plans and facilitate quarterly backup recovery drills & BCP rehearsals;
Drive database backup retention from NAS to offsite, S3 & Glacier on AWS;
Lead to roll-in upgrade SQL Server 2014 AlwaysOn clusters to SQL Server 2016 AlwaysOn multi-subnet Geo-clusters with transactional replication to AWS Redshift via DMS, Glue, Lambda & Lake Formation integration;
Lead to setup Aurora clusters, migrate MySQL/SQL databases, monitor/tune performance of the clusters & databases objects;
Lead to build & migrate SQL databases to RDS, EC2, Redshift, Data Lake, tune performance, compression per best practice;
Design data pipelines to stream/batch transfer data from various data platforms to Data Lake, Redshift/Spectrums, Snowflakes;
Architect Data Lakes to enable silo data discoverable & reusable via Glue, Athena, Redshift Spectrums for analytics, BI & ML;
Guide server provisioning, cluster configuration, performance tuning and query/index/distribution key optimizations;
Define/develop enterprise database system standard & operational level agreement;
Drive to automate workflow, ticketing, tracking, monitoring & notification systems by leveraging infrastructure tools;
Evaluate vendor solutions, manage vendor relations, SOWs and licensing;
Support enterprise Informatica, Talend, SSIS ETL/ELT data pipeline/streaming & MuleSoft integrations;
Support escalated database issues for 24/7 on-calls & participate leadership on-call support rotations

Sr. Database Developer/Architect

Confidential

Responsibilities:

Responsible for server/instance/database/object all level of performance tuning for high traffic & fault tolerant OLTP/OLAP systems of SQL server 2012, 2014, 2016 hosted in data centers & Azure;
Led design centralized master repository to eliminate data conversions, redundancies, discrepancies & network round trips; Built and deployed Data Governance and MDM systems to define, integrate, cleanse & manage data & data flow via MS MDS;
Diagnosed problems/bottlenecks, triaged/resolved issues & recommended solutions across various tiers: application, network, database, server & storage;
Led design/implement/support database security/encryption, audit, database upgrade & migrations;
Led to setup CDC from SQL database to Oracle Cloud & Salesforce; Provided guidance, training & mentorship to AppDev team on database standards and best practices;
Created monitor solutions to report performance & growth, audited changes of all database objects;
Supported HA/DR database solutions, SSIS/SSRS/SSAS processes & ETL/ELT pipelines & Big Data on the cloud;
Near - shore, off-shore support

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship