SUMMARY:

• I have extensive experience in Data Modeling, Relational Database Architecture and Implementation, Systems Architecture and Development, Database Administration and implementation of Administration Standards. Over the years I have been involved in large number of project development, managed large number of Projects & been a DBA with large number of Database Servers.
• 5+ years of experienced to deliver data management vision, goals, priorities, design principles, and operating policies in support of the business goals of the organization.
• Experience in the Agile software development process including working with the business to prioritize requirements into logical and manageable groups for rapid intake into the Agile development process, based on development resource capacity.
• Expert level of experienced to develop database solutions by designing proposed systems, defining database physical structure and functional capabilities, security, backup and recovery model.
• Experienced in determining database structural requirements by analyzing use - cases and performance objectives, including high availability using database mirroring or SQLAlwaysOn availability group and replication strategies.
• Hands-on experience in SQL Server implementation, maintenance, administration and 24x7 support in multi data center environments that includes development, UAT and Productions infrastructure .
• Experienced in Performance Tuning, Backup and Recovery, Query Optimization and Security.
• Experienced in Upgrade/Migration of MS SQL Server 2005/2008 to MS SQL Server 2008R2, 2012 and 2014.
• Experienced in monitoring the health and performance of SQL servers as well as home grown applications using SQL Server native tools and several other third party solutions.
• Adept at T-SQL, stored procedures, tables, indexes, views, functions, and triggers.
• Expert in developing, troubleshooting SSIS (ETL) DTS packages using best practice methodologies and, in a manner, consistent with existing database design objectives.
• Created various SSRS and SSAS Packages to serve company needs.
• Developed and managed reports using SSRS
• Familiar with PCI Compliance Standards required for Retail Industry.
• Expert in using DTA/Extended Events/PerfMon/SQL Profiler/DMVS/T-SQL Scripts and other third-party tools to resolve bottlenecks, dead locks and slow running queries.
• Able to benchmark and load test new instance builds for performance with DB load simulators.
• Responsible for securing SQL Server, user management, assigning permissions and roles.
• Expert in VMware virtualization, Hardware/Software Clustering, RAID and SAN/NAS technology.
• Strong System Administration background in Windows and Linux environments.
• Hands on experience migrating database from premises to Azure Cloud platform
• Experienced in creating technical documentations and process archiving and change management.
• Experienced in working independently as well as in team-oriented environments.
• Expert in problem solving, analysis and conflict resolutions.
• Excellent analytical, communication and interpersonal skills.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

MS SQL Server DBA

Responsibilities:

• Took part in database consolidation project where we have configured AlwaysON infrastructure where we migrated 40+ stand-alone databases . As a result, we were able to centralize multiple databases and servers to share resources and cut licensing and hardware cost.
• Responsible for installing and maintaining SQL Server database systems. Maintaining the database systems includes successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
• Deliver on assigned database infrastructure related projects with participation through project lifecycle that includes new software releases, patch upgrades, prevention of feature exploitation, security and audit
• Responsible for providing SQL Server problem resolution and 24x7 production support and server outages.
• Responsible for installing and configuring MS SQL Server 2012/2014/2016 on Windows server 2012/2016 and applying service packs and security fixes on this MS SQL Servers.
• Involved database migration projects where we migrated 15+ database from on-premises to Azure PaaS platform.
• Created automation of day to day operations, critical SQL server alerts and repetitive tasks.
• Resolved post-migration dependency issues of databases using SSIS packages.
• Monitored the health and performance of SQL server instances and home-grown applications using Extended Events, SQL server Profiler, PerfMon and other third-party tools.
• Tested newly built servers for performance impact with DB load simulators.
• Setup and maintained Log Shipping between various environments.
• Created necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.
• Operated and oversaw database and log backups and restoration, planning backup strategies, and scheduling.
• Backed up user & system databases and restoring them when necessary.
• Optimized the Indexes, adding/deleting them when necessary for better performance.
• Verified backups and error logs on the servers and troubleshoot any failures or alert problems, and open trouble tickets if necessary to work with technicians from other departments.
• Responsible for Installing, configuring and maintaining SQL failover clustering for production environments.
• Involved in improving database performance using Extended Events, SQL Profiler, Trace Flags, Execution plan and DTA and third party tools.
• Worked with installation, configuration and creation of SSRS.
• Responsible for securing SQL Server, user management, and taking care of permissions and roles.

Confidential, Gaithersburg, MD

SQL Server DBA Consultant

Responsibilities:

• Installed and configured SQLServer2012/SQLServer2008 R2/ SQLServer2008 with backup jobs, database mail and configuration options.
• Upgraded SQL Servers with latest service packs.
• Migrated SQL Server databases from SQL Server 2005 to SQL Server 2008 R2.
• Created, administered & maintained SQL Server Databases on Production, Test and Staging for various groups and ensured the availability of the database Servers.
• Configured and maintained transactional replication for flow of data from QA and Dev. Server to the replica servers.
• Monitored data activities like database status, logs, space utilization, locks and long transactions.
• Implemented SQL standards in writing stored procedures, Triggers, Views, SQL functions.
• Worked with developers to optimize the code if required to minimize the duration and look if the indexes were used appropriately.
• Involved in resolving deadlock and blocking issues for concurrent users.
• Provided appropriate access to users except system databases owners.
• Refreshed databases for pre or post data loads activities.
• Supported SQL server developers working on different projects with various requests.
• Converted and redesigned existing DTS packages to SSIS packages.
• Developed SSIS packages to import and export data from existing systems to upgraded system.
• Used database utility programs and 3rd party utilities to monitor database performance, such as Blocking, expensive queries, Memory utilization.
• Escalated database issues to appropriate approvers where applicable.
• Took part in database upgrade project where we have upgraded and migrated multiple databases and servers from SQL server 2005/2008 to MS SQL Server 2012.

Confidential

Database Administrator

Responsibilities:

• Responsible for MS SQL Server 2005 and 2008R2 and database administration.
• 24x7 critical production support for hundred and ten SQL Servers out of which 75 were mission critical production support.
• Created database maintenance plans for SQL backups, optimization, and integrity check and t-log backups.
• Created checklists for proper/unattended install of SQL Server, applied service packs and security fix.
• Involved in validating SQL Servers, which was installed on validated environments.
• Configured and maintained transactional and Snapshot replication for 3 environments.
• Worked with SQL Disaster Recovery processes and documented/revised those processes.
• Worked with capacity planning, database sizing and monitoring.
• Created databases, tables, indexes, stored procedures and triggers, alerts and maintained user permissions.
• Involved in creating DTS Packages to import and export operations in and out of SQL Servers.
• Applied monthly patches and hot fixes. Worked with application team to test the successful upgrades.
• Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
• Installed and configured SQL Server Analysis services (SSAS) for data warehousing projects.

TECHNICAL SKILLS

Languages: T-SQL, HTML, CSS, JavaScript, Ruby, .NET, Java, Python, PowerShell and XML

ETL Tools: SSIS, BI (BIDS/SSDT).

Data Modeler: SSAS, SQL Developer Data Modeler, TOAD Data Modeler.

Reporting & Audit Tools: SSRS, Report Builder and SSDT, Idera SQL Compliance Manager and SQL Secure.

Backup Software: SQL Backup, RedGate, Idera

RDBMS & Tools: SQL Server 2005/2008/2008 R2 and 2012, MS Access 2003/2007/2010/2013 Operating System Windows XP/Vista and 7, 8, Windows 2008 and 2008R2, 2012 servers and VMware, Hyper-V virtualization.

Third Party Tools: RedGate, Spotlight, and Idera SQL suite, Toad Development Suite, Maintenance Scripts, PuTTY, Wireshark, GiT, Chef.

DB Query Tools: MS SQL Server Query Analyzer, SQL Profiler, ETL, SSMS