Sql Server Disaster Recovery
Resume:
SHESHANK DESHAM
Austin, TX
********.******@*****.***
Experienced DBA with over 10 years of experience installing, upgrading, and configuring SQL Servers on Windows and Linux. Proficient in supporting multiple databases including SQL, Oracle databases, MongoDB, Solr, Snowflake DW and AWS RDS instances. Proven ability to maintain database security by upgrading/patching instances and following the principle of least privilege for users. Skilled in assisting and implementing high availability and disaster recovery strategies. Proficient in monitoring and optimizing database performance. Experienced in provisioning infrastructure with Chef and Terraform.
WORK EXPERIENCE
Senior DBA (MS SQL/MongoDB/AWS)
11/2021 to present
Uship
Austin
Spearheaded database administration and management across diverse environments, encompassing installation, maintenance, upgrades, and round-the-clock monitoring and support for Microsoft SQL Servers, MongoDB, AWS Aurora, DynamoDB, Snowflake and Solr.
Oversaw a team of DBAs dedicated to upholding the integrity and reliability of the organization's databases.
Led the transition of SQL Server instances from on-premises environments to AWS EC2 and RDS platforms, optimizing resource utilization and scalability while ensuring uninterrupted service delivery.
Implemented and maintained disaster recovery solutions on AWS by establishing SQL Server Always On configurations with listeners, ensuring seamless failover capabilities, and orchestrating scheduled database backup file restores. Additionally, configured replication for MongoDB and Solr to enhance data redundancy and availability in alignment with business continuity requirements.
Executed performance tuning strategies for SQL Server, incorporating proper instance sizing, storage enhancements, and stored procedure optimizations, resulting in improved system responsiveness and efficiency.
Implemented and managed Transparent Data Encryption (TDE), backup encryptions, and patching protocols to fortify data security measures.
Utilized Terraform to provision infrastructure and enact modifications to existing AWS infrastructure.
Leveraged PowerShell and Python to automate database administration tasks, including backups, restores, monitoring, reporting, and data processing, enhancing operational efficiency and streamlining data workflows.
Proactively monitored resources and applications using RedGate, ElasticSearch, and AWS CloudWatch, configuring alarms for metrics such as EBS, EC2, RDS, S3, SNS, and DataSync, with notifications tailored to defined events.
Ensured the maintenance of up-to-date technical documentation, including architecture and integration diagrams.
Analyzed production workloads and devised strategies for optimizing Snowflake performance and scalability.
Collaborated within a team environment to provide 24/7 on-call support for production databases.
Senior Database Administrator (MS SQL/Oracle/AWS)
10/2014 to 11/2021
Acxiom Austin
Install, patch, and configure SQL Server versions 2012 to 2019 manually, using config file, or chef on standalone and cluster environments on Windows and Linux OS.
Proficiency and expertise in high availability, scalability, and disaster recovery features such as Always on Availability Groups, SQL Server Replication, SQL server Mirroring, Log shipping, Backup/Recovery.
Strong knowledge of SQL Server security procedures, database security audits, upgrades, migrations, and consolidations.
Expert in monitoring SQL Server Performance using Database Engine Tuning Advisor (DTA), SQL Profiler, Index Tuning Wizard, Windows Performance Monitor, and other third-party tools to resolve bottlenecks, dead locks and slow running queries.
Created active scripts to monitor SQL Servers and generate alerts which monitor backups, storage, database size, consistency checks and service status monitoring.
Prepared Root cause analysis (RCA) and documentations regarding technical design, high level system flows, project plan, requirements & solution, code reviews and issues, modification processes and weekly status reports for project management.
Involved with installation of Oracle 19C databases using chef and patching of Oracle instances with OPatch, RPM or Chef.
Experienced in database migration tools such as Oracle data pump and export/import
Support AWS RDS. Upgrading DB instance engine version and encryption. Migrating multi-TB databases to AWS RDS SQL Server using Snowball device.
AWS certified in SysOps associate, Solutions Architect Associate and Cloud practitioner
Experienced in supporting Snowflake Datawarehouse with RBAC, monitoring, and optimizations.
Snowflake SnowPro Core certified and hands on essentials badge in Data Warehouse, Data Sharing and Data applications.
Azure AZ-900 Fundamentals certified
24 X 7 Production Database on Call Support
SQL Server DBA/Developer
01/2013 to 10/2014
Firtucon Inc.
Conway
Installed SQL Server 2012 and SQL Server 2008 R2, applied service packs and security hot fix for all servers.
Actively involved in the migration/upgrade process of the SQL Server 2000 to 2008 R2 environments. Implemented the Database Mirroring in SQL Server 2005/2008 R2 for high availability feature. Configured and maintained Log shipping architecture to provide backup server solution for production environments.
Proficient in implementing different types of Replication models like Snapshot and Transactional.
Created active scripts to monitor SQL Servers and generate alerts which monitor backup, drive space, log, database size and service status monitoring.
Administrated the configuration and performance of the databases using best practices recommendation.
Implemented DB maintenance plans by appropriately re-indexing the indexes to resolve fragmentation. Analyzed and addressed DB performance issues to resolve the blocking, deadlocks and optimized the performance.
Monitoring DB space growth in SQL servers and working with different teams to get them sorted out.
Created Database Objects Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
Monitored performance and optimized SQL queries for maximum efficiency using query execution plans, SQL DMV s, Profiler and using appropriate isolation levels.
Administering the MS SQL Server by creating user logins with appropriate roles, dropping the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups. Designed and implemented the Logical and Physical model of the database using Erwin.
Developed Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects
Designed and deployed SSIS packages using BIDS. Used SQL Server Agent to automate the SSIS package execution. Tested and managed the SSIS packages.
Business System Analyst
04/2012 to 11/2012
Bartronics
Conducted regular customer and workgroup meetings for multiple SDLC efforts
Created SRS (Systems Requirement Specification), Wireframe/Storyboard, QA/UAT plan, and System Reference Guide documentation
Prepared process and data models; used Visio to create workflow, entity relationship, Use Case, Activity
Diagrams, and other Unified Modeling Language (UML) based diagrams
Performed and led all analysis and testing for Crystal Reports
Created and updated Microsoft SharePoint sites for project teams in order to establish better collaboration and communication
Supported Project Management with scope definition, cost/benefit analysis and project plan creation
Provided accurate and timely analysis task time estimates
Researched and helped resolve customer data inquiries by utilizing SQL queries
Worked with Project Managers, Developers, Business Systems Analysts, Quality Assurance analysts and other team members to ensure that project timelines and budgets were met
Facilitated and organized User Design Review and prototype sessions, Organized and participated in employee interviews
Oriented and trained business systems analysts on EA team processes and methodology
Intern Business Systems Analyst
01/2012 to 03/2012
New York Times
New York
Receive and verify invoices and requisitions
Verify transactions and payment documents
Prepare invoice batches for inventory and entry into database
Manage weekly and monthly check runs
Prepare checks and log them in the logbook Maintain lists of accounts payable and receivable translating business requirement into system requirement
Maintain general ledge and P/L account
Take phone calls and file records
EDUCATION
Berkeley College
Bachelor’s
Information Systems
New York
Certifications
AWS SysOps Associate
AWS Solutions Architect Associate
AWS Cloud Practitioner
Azure AZ900
Snowflake SnowPro Core certified
Snowflake hands on essentials badge: Data Warehouse, Data sharing and Data applications
Contact this candidate