SUMMARY

• Dedicated and motivated graduate, seeking position of Database Administrator/Developer where I can apply my experience to help organization grow.
• A position as a Senior SQL DBA where my significant SQL functional and technical knowledge and team work skills will be of great value to SQL Implementation and support projects.
• 8+ years IT experience in Database designing, Architect, Development, Administration, BI (SSIS and SSRS) and Infrastructure Services support & management with various business domains like Financial, Healthcare pharmaceutical, Insurance.
• Database Administration and Development for very large and complex databases in SQL Server comprising of OLTP and OLAP environments.
• Experience in an operational environment providing support involving coordination with release management and change management.
• Expertise in installing and configuring based on CIS standards MS SQL Server, updating with latest service packs, hot fixes, cumulative updates and security patches.
• Dexterity inimplementingdifferent types ofHigh Availability & Disaster Recovery scenarios using Always on High Availability groups, Replication models (Snapshot, transactional, Merge), Log Shipping,Database Mirroring and Clustering.
• SQL Server Consolidation & Virtualization using VMware, Hyper - V
• Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor, Query Store, Database Tuning Advisor (DTA), Extended Events, Dynamic Management Views(DMV) and DMF
• Worked with Developers for query optimizations, performance tuning, package deployments, code changes etc.
• Proficient with database backup/restore, recovery procedures, index maintenance, production security standards, change requests etc.
• ImplementingTLS and SSLAuthentication on the database server to help secure data
• Proficient working with Data Encryption technologies available like TDE, Always Encrypted, Dynamic data masking
• Design SQL Server Partitioning solutions for Very Large database tables to Purge, Archive data and also reduce maintenance, improve performance and enable "Piecemeal Restores"
• Review Transact SQL code from developers to ensure adherence to standards and best practices.
• SQL Server Database Audit
• Migrate SQL Server databases from any version of SQL to any version.
• Track Performance changes using Query store and plan freeze
• Experience in migrating SSIS packages Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined datatypes, and Indexes using T-SQL.
• Exposure to Visual SourceSafe, TFS, Tortoise, bit bucket, GitHub version controlling.
• Experience with third party backup tools Veritas Netbackup/Commvault/Avamar/Litespeed
• Assist developers withquerytuning and schema refinement
• Experience more toward doing analysis and implementing performance improvements
• Ability to work independently and collaborate with teams
• PowerShell Scriptingto automate database/Server level activities like monitoring disk space, Status of services etc.
• Experienced in ITIL process (Change Management, Release Management, Problem Management, and Incident Management) and IT Infrastructure, RAID environment.
• Experience in Troubleshooting and documenting root cause analysis.
• Implemented new SQL Server features by performing successful POCs
• Worked on the SOX,PII,HIPPA, PCI SOX Compliance areas
• Provide 24x7 support for critical production systems
• Refine and automate regular processes, track issues, and document changes
• Used Monitoring tools Solar Winds, Idera, Red Gate, Precise I3

TECHNICAL SKILLS

Databases: SQL Server 2019/2016/2014/2014/2012/2008 R2, Azure database, MySQL 8.0, 5.7 and MSAccess.

Database Tools: SQL Server Management Studio, Query Optimizer, SQL Profiler, Bulk Insert and BCP, ODBC, Business Intelligence Development Studio (BIDS),Informatica.

Languages: T-SQL, Power shell, batch scripting, Azure CLI

Reporting Tools: SQL Server Reporting/Analysis Services(SSRS)

Change Management Tool: Tortoise SVN, Visual Source Safe (VSS), Team Foundation Server (TFS),Bit Bucket, GIT

Servers: WindowsSQLserver, Azure Managed Instance,AWS-EC2Instance

PROFESSIONAL EXPERIENCE

Confidential, West Palm Beach, FL

Senior Database Administrator

Responsibilities:

• Maintaining SQL Server 2019, 2016 & 2008 Production Servers
• Migrating SQL Server 20 and SQL Servers
• Encrypt sensitive data using MS SQL Server Always Encrypted, Dynamic Data Masking
• Migrating SQL Servers to AWS and PostgreSQL And Managing PostgreSQL Databases
• Maintaining Prod, Test and Dev Environments and taking care of Ad hoc requests
• Knowledge onCloud computing architecture, technical design and implementations including Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS)
• Maintained Databases size up to 2 TB
• Migrated SQL servers from on perm toAzureenvironments.
• Taking care of SSIS Packages and SSRS Reporting features across all environments
• Installed and maintaining SQL Servers in Virtual VMware system environment
• Provided 24x7 production database support
• Performance tuning complex queries based on the issues
• Automated windows and SQL Jobs using PowerShell
• Using T-SQL Stored Procedures, Functions and Triggers whenever required for ongoing development requirements, SSIS Packages and SSRS Reporting
• Have installed Power BI and worked on Power BI Reporting whenever required
• Working closely with other developers, project management, and key stakeholders
• Designing new schemas and databases according to the new business and application requirements
• Performance tuning and Query Optimization using extended events, query store and plan guides
• Build a customized solution for SQL vulnerability Assessment of all instances to meet CIS standards
• Proactive monitoring Collect data across enterprise and generate alerts
• Configure and maintain Always on Availability groups and transactional, Merge replication
• Provide 24x7 support for critical production systems

Environment: Windows 2016/2012/2008 R2, MS SQL Server 2019/ 2016/2012/2008 R2, MySQL 8.0, SQL Server Data Tools, SQL Server Migration Assistant, BIDS (SSIS & SSRS), Query Store, Extended Events, Compression, T-SQL, MS Office

Confidential

SQL DBA/Developer

Responsibilities:

• Created best practices, guidelines for designing secured and optimized SQL Server database systems.
• Installed, security, and maintenance of Linux based systems MySQL 5.0.22 configuration
• Designing, creating and deploying SSIS packages for data feeds and to automate the monthly process cycles.
• Designing physical and logical database schemas and normalizing databases.
• Designing, creating, deploying and rendering sales reports, dashboards and other domain reports using SSRS
• Created best practices, guidelines for obfuscating data while moving data from production to dev and test environments.
• Designing, implementing and rendering dashboards, charts and other reports using SSRS.
• Creation of Views, Cursors, SP, User-defined Functions according to the User requirements
• Troubleshooting and recommended best practices performance issues in production systems
• Created guidelines for T-SQL coding and implemented the guidelines
• Monitoring database health, I/O, CPU, memory, space, locks and blocks.
• Created methodologies and automated database health checkups on daily, weekly and monthly basis.
• Suggested dot net and SQL developers and in designing and developing T-SQL code
• Investigated and resolved performance issues in production environment.
• Tuned stored procedures and SQL queries and got drastically improvements.
• Designed backup and recovery methodologies and implemented in production environment.
• Worked and tuned on complex T-SQL queries and stored procedures.
• Recommended and implemented database process improvements.
• Planning and implementing database activities that include service pack upgrades, data archive movements and database migrations across the servers.
• Created methodology and upgraded from SQL Server 2008 to SQL Server 2012
• Writing/updating stored procedures, functions, views, triggers and other database objects
• Creating and Maintaining scheduled jobs, Maintenance plans, database native and Litespeed backups and maintenance plans.
• Designing and implementing database maintenance and release processes.
• Designing and implementing lot of service improvement processes that includes automating daily, weekly and monthly maintenance activities.
• Handled the upgrade process for SSIS packages from SSIS 2008 to SSIS 2012
• Performed MySQL Replication setup and administration on Master-Slave and Master-Master

Environment: SQL Server 2005/2008/R2 /2012, MySQL 5.7, Windows Server2003/2008/R2, LiteSpeed, SSIS, SSRS, Robo Copy, VSS, WATSUP Monitor, Liquid Planner, T-SQL, Batch Programming, ZOHO Tool, MySQL 5.6, MySQL Workbench

Confidential

Data Base Administrator

Responsibilities:

• Involved in installing and configuring of SQL server 2008 and 2008R2 on standalone and clustered environments.
• Installed SQL 2008 standard edition with SP1 for testing present application and migrating test databases to test any upgrade issues.
• Disk swap on existing clusters
• Build 5 Node active passive cluster to use resources more effectively
• Work on effective solutions to bring data from M/F to SQL server
• Hands on experience in red gate data compare, schema compare and data generator
• Task lead for migration of data from three sources two SQL databases and a pro flat file database to two new SQL databases.
• Installed Idera diagnostic manager to monitor all PROD servers
• Production support and on call on Rotation
• Involved in data modeling, designing and building relational databases using Erwin tool.
• Implemented database mirroring between primary server and a standby server.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Creating and managing schema objects such as tables, views, indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Creating databases and logins with permissions in SQL server 2008 as per the developer’s request.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Prepare daily report on the job failures, backup failures and disk space and implemented an e-mail notification solution to be notified when a threshold or error is encountered.
• Involved in resolving dead lock issues and performance issues.
• Created and scheduled jobs to setup log shipping between production servers as well as standby servers.
• Disk configuration to implement availability and reliability, which usually transfers into Redundant Array of Inexpensive Disks (RAID) and Storage Area Network (SAN)
• Experience in installing and configuring clustering to provide high availability and scalability.
• Optimized queries and stored procedures for better performance
• Used SQL assistant for writing advance SQL queries, and used xSQL data compare to compare databases and tables for sync between dev, test and production.
• Coordinating with the development team regarding tuning the SQL queries and stored procedures.
• Worked as team lead to manage Offshore implementation and support teams
• Identifying the bottlenecks and troubleshooting it for optimal performance.
• Responsible for MS SQL Server 2008, configuration, tuning and provide support to all production and development servers.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Configured transactional replication between primary server and three read only servers, with separate distributor server and experience in troubleshooting replication problems.
• Extracted, transformed, and loaded data (ETL) by Writing SQL queries, running queries, exporting data, importing and scrubbing data with Excel or Access
• Successfully migrated SQL 2000 DTS packages to SSIS using DTS xchange tool.
• Additionally, designed and implemented a disaster recovery system.
• Running index tuning wizard and rebuilding indexes for faster query response.
• Created the logical and physical data modeling using Erwin tool.
• Maintain operators, categories, alerts, notifications, jobs, job steps and schedules. Monitor connections, locks and performance of SQL server.
• Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins (Windows and SQL accounts).
• Created documentation to install SQL server, apply service pack, hot fix and clustering installation.
• Worked with various tasks of SSIS like transform data task, execute SQL task, and active script task etc.
• Expertise in security issues such as creation and granting permissions on various objects.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes.
• Scheduling SSIS packages, Fuzzy Look-up for cleaning bad data, validating data using SSIS wizard

Environment: MS SQL Server 2000/2005/2008 , Windows 2000/2003 servers, Active Directory, IIS Web server, DTS, SQL Upgrade Advisor, MS Access, Microsoft Analysis Services,VMware3.5, Diagnostic Manager, Microsoft Reporting Services, UNIX, Power shell, Microsoft SQL Server Integration Services(SSIS), Litespeed