SUMMARY

• 6 years of experience in database administration, production support, design, development, and implementation using MS SQL Server.
• Good knowledge in Tuning SQL queries, T - SQL, and PL/SQL queries & improving the performance of the Database.
• Good knowledge in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors, and SQL on databases: MySQL, and DB2.
• Good experience in using T-SQL for developing complex stored procedures, triggers, tables, views, user functions, user profiles, relational database models and data integrity, SQL joins, and query writing.
• Experience in extracting and transforming transactional information using DTS Import/Export wizard and BCP (Bulk Copy Program) from SQL Server.
• Good knowledge of TOAD for ERWIN as tools to manage databases.
• Experience in Data Extraction, Transforming, and loading ETL using various tools such as SQL Server Integration Services SSIS.
• Scheduled many jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
• Hands-on experience with Installation, Configuration, Patching, upgrading, and migration of databases.
• Experience in using all types of SQL Server Constraints, SQL Server Database design, Database maintenance, developing Transact- SQL queries, stored procedures, and triggers using SQL Servers.
• Used tools like Index Tuning Wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Experience in Enterprise Reporting in generating reports using linked reports, sub-reports, and filters, charts in SQL server reporting services.
• Strong experience in creating various reports like Drill through, Drill down and Ad-hoc according to the user requirement using SQL Server Reporting Services (SSRS).
• Experience in creating and maintaining different data structures.
• Experience in creating visualizations, interactive dashboards, reports, and data stories using Tableau.
• Experience in working with different operating systems like Windows and Linux.
• Good customer management/resolution, problem-solving and debugging skills with good verbal/written communications and presentation skills.

TECHNICAL SKILLS

• SQL
• PL/SQL
• T-SQL
• DB2
• MS SQL Server
• MySQL
• SSMS
• SSIS
• SSRS
• OEM
• DTS
• BCP
• TOAD
• Tableau
• ERWIN
• Data visualization
• UML
• MS Visio
• Windows
• Linux

PROFESSIONAL EXPERIENCE

Confidential, PA

SQL Developer/Administrator

Responsibilities:

• Developed highly optimized store procedures, functions, and database views to implement the business logic.
• Created clustered and non-clustered indexes.
• Created SSIS packages to load the XML, Excel and Flat files to data warehouse.
• Identified the slow running queries, store procedures and views by running the SQL Profiler and improved their efficiency by performing performance tuning.
• Writing TSQL, Triggers, Store procedures, Functions, and creating and maintaining the database structures.
• Day to Day maintenance of the database, Agent Jobs, Backups and Restore databases.
• Creating and managing the Table Indexes, Query and Performance Tuning and Deadlock management.
• Implemented Logins, security, roles and permissions to the users.
• Deploy the code into different environments like UAT, DEV, Test.
• Enhanced existing views, store procedures and database objects to meet the new requirement.
• Configured and maintained Log Shipping, DB Mirroring, and Replications for the High Availability and DR.

Environment: SQL Server, SSMS, SSRS, SSIS, SQL Profiler, MS EXCEL, Visual Studio, Share Point, oracle.

Confidential, TX

SQL Developer/Administrator

Responsibilities:

• Create new Tables, queries, views, and stored procedures for production support using SSMS.
• Monitor, troubleshoot, and resolve data processing issues to maintain daily data feeds and data integrity Using SSMS.
• Design/Build Extract Transform Load procedures in SQL Server using DTS packages to import/export data feeds to/from the data warehouse.
• Involved in Dashboard design and SSRS report development.
• Generated the reports for whichever the jobs are disabled/failed in the Prod Server.
• Designing logical and physical database structures to facilitate the analysis of data from both operational and customer perspectives.
• Involved in UAT for newly developed reports, dashboards and involved in end-to-end testing for the migration and server upgrades.
• Providing the support in the performance tuning and maintaining the Database.
• Performance tuning, query analysis, and maintenance routines.
• Develop and maintain SQL procedures, views, and other scripts in support of production development, customer reporting, and database administration requirements.

Environment: SSMS, SSRS, My SQL, MS SQL Server, MS Excel, Visual Studio.

Confidential, PA

Production Support Engineer

Responsibilities:

• Worked in the IT Production Support team to ensure availability and zero downtime of applications.
• Worked with the end users and Higher management by attending operational calls and emails to troubleshoot the application related issues.
• Co-ordinated with the Development team to successfully deploy the releases in the different production environment.
• Created, performed, and maintained Database backup and recovery operations using SSMS.
• Created and maintained the databases and servers using SSMS.
• Performed performance tuning by using SQL scripts to enhance and improve the performance of the database.
• Troubleshooting the slowness and latency database and server related issues.
• Create new Tables, queries, views, and stored procedures as per the requirement.
• Interacted with the end users to resolve their issues and educate them regarding the newly deployed feature of the application and the process flow.
• Identified and resolved the agent job failure issues.
• Interacted with the higher management to mitigate the Database and server related issues.
• Attending the operational calls from the end users to resolve their issue and educate them.
• Responsible for providing day to day ticket and unresolved issue status.
• Created weekly and Monthly deck for the issues faced by the users and the ticket statistics and representing them to the higher management.
• Good Understanding in API infrastructure and the API calls of the application.
• Configuring the SharePoint systems as per specified requirements.
• Created the Business Documents and configured it on the Share Point as per the requirements.
• Extending SharePoint functionality with forms, web parts, and application technologies.

Environment: SSMS, SSRS, MY SQL, MS OFFICE, MS SQL Server, Share Point, Remedy (ticket Management Tool), Rally.

Confidential, NJ

SQL Database Administrator

Responsibilities:

• Monitored different databases and application servers using MS SQL Server.
• Performed backup and recovery procedures, monitoring SQL Server logs, SQL Agent Job failures, and transaction log file sizes, and performance tuning.
• Supporting and Managing all the SQL Server databases across the organization.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views.
• Design/Build Extract Transform Load procedures in SQL Server using DTS packages to import/export data feeds to/from the data warehouse.
• Create new Tables, queries, views, and stored procedures for production support.
• Designing logical and physical database structures to facilitate the analysis of data from both operational and customer perspectives.
• Develop database Backup and Recovery and Disaster recovery strategies scheduling full and incremental backups using SSMS.
• Daily DBA activities like Tuning of SQL, PL/SQL, Performance Tuning, Database auditing, and managing user groups, Database security.
• Installed and Configured SQL Server Reporting Service (SSRS) in Prod, Dev, Test, and UAT environment.
• Configured and maintained Log Shipping, DB Mirroring, and Replications for the High Availability and DR.
• Performed capability planning and performance tuning as well as database migration from DB2 to SQL Server database.
• Generated the reports for whichever the jobs are disabled/failed in the Prod Server using the PowerShell Automation Script.
• Maintain/manage database agent jobs, check for failures, and resolve failure issues.
• Worked on AWS database migration services for migration of databases.

Environment: MS SQL Server, SQL, PL/SQL, DTS, SSRS, SSMS, AWS, Oracle, PL/SQL, DB2, Excel.

Confidential

SQL Database Administrator

Responsibilities:

• Creating and managing schema objects such as Tables, Views, Indexes, Stored Procedures, and User-Defined Functions depending on the Requirements Using T- SQL.
• Performed logical backup using export/import and data pump utilities.
• Configuration Assistant and SQL Server Management Studio (SSMS).
• Developed and deployed different types of Reports using different data sources like SQL Server, Excel, CSV files.
• Utilized Tableau and custom SQL features to create dashboards and identify correlation.
• Responsible for setting and managing User Management, Space management Granting required privileges to users.
• Work in developing and maintaining functions, procedures, triggers, indexes using the MYSQL database.
• Deployed SSIS packages to move data across server, move logins, load data from different data sources
• Routine Database Administration tasks such as Space Management, User Creation and Maintenance, Upgrades, and Patches.
• Monitored data activities such as database status, logs, space utilization, extents, Checkpoints, locks, and long transactions.
• Performed database migration from DB2 to SQL Server database.
• Involved in requirement gathering and data analysis and Interacted with Business users to understand the reporting requirements.
• Generated Report using SSRS and in Excel, html, text from Database.
• Set up security and access profiles and procedures for database system administrators.
• Set up and administered tablespaces, data files, tables, indexes, views, and sequences Configured and managed users, security, and redo logs.
• Other duties include applying SQL Server database patches, creation of database users, monitoring, tuning, troubleshooting, and backup and recoveries, monitoring and optimizing database performance.

Environment: SQL Server, Tableau, DB2, T-SQL, MySQL, Erwin, SSMS, SSIS.