SUMMARY:

Dedicated and motivated data management professional with Confidential strong background in Relational Databases and Analytics. 18 Years of successful experience consulting on multifaceted database projects and fostering positive relations with Confidential wide range of key business partners. Consistently recognized for outstanding contributions to the bottom line. Solid reputation for resolving complex issues. Commended for perseverance, efficiency, and project management skills.

AREAS OF EXPERTISE:

• Database Administration 18+ years
• SQL/T - SQL Programming 18+
• Database Design 18+ years
• Performance tuning 18+ years
• Python 4 + years
• PowerShell 6+ years
• Amazon AWS 6+ years
• Machine Learning 3+ years
• DevOps / CI - CD 2+ years
• & Team Building
• Application Development
• Process Improvement
• Microsoft Certified DBA
• AWS Solutions Architect

RECENT EXPERIENCE:

Sr. Cloud Architect, Sr. SQL Server DBA / Architect

Confidential, New York, NY

Responsibilities:

• Responsible for managing SQL Server databases systems hosted across 2008/2012/2014/2016 platforms, running on both physical, and virtualized infrastructure in Confidential 24 x 7 environment.
• Configured, implementing and supported large highly available SQL Server environments with various high availability techniques including Failover Cluster, AlwaysOn, and database mirroring.
• Mentored and trained developers and other DBAs in concepts related to data retrieval, data analysis, data integrity and analytical information systems in RDBMS environments
• Lead cloud migration project by evaluating on-prem capacity and created Confidential cost-effective plan for migration of 20 applications
• Prepared, Planned and Executed migrations from on-prem database servers to virtualized infrastructure as well as to AWS and Azure cloud
• Built docker containerized SQL Server databases
• Implemented open source monitoring tools to monitor patterns of database utilization, wait statistics and IO perf
• Using python functions implemented cross region disaster recovery for EC2 and RDS SQL Server instances
• Utilizing PowerShell, Chef and terraform developed DevOps automation to configure Infrastructure as Service
• Implemented CICD pipelines to automatically deploy database source code to pre-production environments and prepare production deployment scripts.
• Configured SQL Server reports, data-driven subscriptions, and timed executions
• Designed SSIS packages to transform data from various sources for cube processing
• Performed application load test by capturing production traffic and replaying it on individual machines in real time. Identified and addressed performance issues due to cardinality estimation SQL Server changes
• Identified and fixed performance bottlenecks by tuning and Stored Procedures optimizing indexes and reducing serial function calls
• Produced detailed technical assessments and documentation of issues to communicate with senior management during and after application migrations
• Performed DB I/O performance tuning by running load generating tools, selecting Provisioned IOPS for databases
• Drastically improved TempDB performance by placing temporary data onto locally attached ephemeral storage
• Architected secure, scalable and highly reliable tree node SQL Server clusters with AlwaysOn spanning across 2 data centers. Implemented data migration plans to ensure Confidential smooth migration from SQL Server
• Scripted terraform configurations to automatically provision and maintain database instances
• Authored scripts for automating maintenance, and migration processes using PowerShell, Shell and T-SQL
• Created standards for SQL Server databases ensuring use of optimal database server configurations for security and performance.
• Created PowerShell scripts to pre-configure windows for SQL Server installation, install SQL Server and configure its features such as min-max memory, max DOP, security, TempDB, and backups.
• Developed and implemented Data warehouse on SQL Server viewership tracking integrating data from daily impressions/clicks of display ads, impressions/clicks of video and display ads.
• Assisted in migrating Oracle databases to Aurora PostgreSQL by migrating schema and user data

Sr. Cloud Architect / Sr. SQL Server DBA

Confidential, Chicago, IL

Responsibilities:

• Architected SQL Server databases in support of Mobile App and kiosk ordering
• Managed highly available and performance intensive database infrastructure across US, Canada, Europe and Asia-Pacific markets
• Developed database and system configuration automation using PowerShell
• Deployed monitoring and alerting solution
• Lead Confidential team of DBAs troubleshooting issues, performance tuning and implementing best practices
• Provided solutions to improve performance, established high availability and DR
• Designed monitoring solution to ensure Microsoft SQL Server Servers uptime
• Architected and implemented solution for telematic data capturing, gathering 1TB of data per month
• Setup configured SQL Server Always-on availability, Replication, Mirroring and Windows Clustering

Confidential, Arlington, VA

Responsibilities:

• Manage large database environments with highly transaction environment supporting trade desk.
• Designed and implemented Always On and SQL Server replication across On-perm and DMZ
• Created PowerShell scripts for maintenance and data import / export to S3 on AWS

Confidential, Dallas, TX

Responsibilities:

• Provided production support. Tracking and resolving database related incidents within SLAs
• Reviewed service related reports (e.g. database backups, maintenance, monitoring) on Confidential daily basis to ensure service related issues are identified and resolved within established SLAs
• Lead Confidential team of DBAs Responding to database related alerts and escalations
• Collaborated with Application team to come up with strategic solutions to recurring problems
• Initiated and performed changes on production systems, as well as pro-actively escalate any issues that could not\ be resolved within the established time-frames.
• Provided 24/7 monitoring and production support

Confidential, New York, NY

Responsibilities:

• Architected Database for Money transfer, bill pay and pre-paid debit card services
• Designed solution for mobile payments and integrations with 3th party providers
• Responsible for performance tuning including query, storage and workload tuning
• Implemented disaster recovery solutions

Manager, Database Administration

Confidential, New York, NY

Responsibilities:

• Oversee on-call production support and supervise Confidential team of 6 DBAs and developers
• Develop operational plans and budgets in accordance with company goals and policies
• Gather requirements, generate estimates, and administer change management
• Implement disaster recovery, business continuity, and global server load balancing solutions
• Initiate SAN storage configurations and created Table partitions based on Date ranges
• Set up transactional replication and high-performance database mirroring for DR environments
• Using SSIS and DTS to implement ETL process and import data to databases
• Migrate and upgrade SQL databases while consistently monitoring SQL server performance
• Establish documentation standards and processes to help increase productivity