SUMMARY

• Over 17 years of IT experience, this includes analysis, design, development, testing and implementation of applications, reports and databases (MS SQL Server 2016/2014/2012/2008 R2/2005). Expertise in SQL Server, SSIS and SSRS and currently working as SQL Server Database Administrator for last 9 years.
• Design, develop and maintain large - scale production and test databases. Monitor daily logs and security audits on all Microsoft SQL servers. Assist developers in creating and supporting production applications.
• Create database, tables, stored procedure on request. Give user access and SQL Server installation. Apply MS SQL security patches. Database backup up and restore.
• Work on user request to move tables, stored procedure, functions etc. from Development database to Production database environment.
• SQL Server Installation, Upgradation, Migration and security patch update.
• Configure and maintain SSRS(Reporting), SSAS(Analysis) and SSIS(Integration).
• Database and Log Backups. Restore database. Audit log monitoring and review.
• Create and maintain JAMS jobs. Migrate database and objects to new server.
• Work closely with IT Security and Sys Admin team for SQL security findings.
• Creating and Monitoring SQL server Jobs. Expert in dealing with alerts, operations and job scheduling through SQL server agent.
• Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB etc. Also deployed DTS/SSIS packages in different environment (TEST/QA/PRODUCTION)
• Experience in migration of DTS packages in to SSIS packages.
• Extensive experience in writing and analyzing complex stored procedures, cursors, triggers, Joins, views and user-defined functions.
• Experience in .NET framework using ASP.NET, C#, ADO.NET database connectivity.
• Worked on .Net RDLC reports, crystal reports and have knowledge of SSRS.
• Experience in MS SQL Server configuration, client/server connectivity, maintaining and monitoring Database Consistency Checks using DBCC.
• Proficient in analyzing query plans using extended stored procedures, creating and managing Indexes and locks
• Experience in query optimization & performance tuning of stored procedures and function.
• Resolving tickets (Incident, Problem or Change order) of different priority with in SLA time.
• Recognized ability to communicate through written / verbal contexts, with demonstrated ability to convey technical information to both technical and non-technical audiences, and to analyze and translate client requirements into functional specifications for the client and detailed system specifications for the development.

TECHNICAL SKILLS

RDBMS: SQL Server 2016/2014/2012/2008 R2/2008/2005

Database Tools: SQL Server Enterprise Manager, SQL Profiler, SQL Server Agent, SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)

Operating System: Windows 10, Windows 2012/2008 R2, XP, 2003, 2000, NT, 98, 95

Languages: T-SQL, ASP.NET, C#.Net, VB.NET, Visual Basic 6.0, ASP

Programming Environments: Visual Studio.NET 2015/2010/2008/2005, Visual Studio 6.0

Scripting Languages: VB Script, Java Script, XML, PowerShell

Reporting tools: SQL Server Reporting Services (SSRS), Crystal Report, RDLC, Dundas Chart

Office Tools: MS Excel, MS Word, MS Access, MS Power Point, MS Visio, MS Outlook 2010, Office 365, MS PowerPoint

Version Control Tools: TFS 2015/2010/2008/2005, MS Visual Source Safe 6.0

Other Tools: SecureFX 6.2, Bomgar, Snagit 9, Lotus Notes 8.5, HP OpenView, ORSYP ($Universe), Corediant, Ignite, APM, JAMS, Splunk

PROFESSIONAL EXPERIENCE

SQL Server Database Administrator

Confidential

Responsibilities:

• Design, develop and maintain large scale SQL Production and Test Databases.
• Create the system requirements and design specifications for database management.
• Troubleshoot SQL Server service outages as they occur.
• Analyze, coordinate with stake holders and provide best solution for database performance.
• Follow Authority to Operate (ATO) documentation process for all the SQL controls.
• Database design documentation, server configuration and changes using BMC Remedy ticket change management process.
• Create database, tables, view, SP, functions, linked server, SQL jobs, user access.
• Work on developer change request to move database objects and advise on the most efficient database designs (tables, datatypes, stored procedures, functions etc.)
• Create and maintain SQL jobs and configure job scheduling and troubleshoot job failure.
• Grant access, create linked server connections, manage Indexes and locks.
• Creating and analyzing complex stored procedures, cursors, triggers, Joins, views and user-defined functions.
• Create and move databases to different environment and maintain the technical documentation.
• Query Optimization, Performance Tuning, Normalization, Database Mirroring.
• Performance tuning, Identify missing indexes, tuning stored procedures and making sure the query have best execution plan.
• Guiding developer for complex queries and optimization of processes and statements.
• SQL performance and active monitoring using windows and SQL tools.
• Run various database and windows reports on SQL Server to improvise CPU resource usage, memory usage, index statistics etc.
• Database mirroring for high SQL Server availability.
• SQL Server Installation, Upgradation, Migration and security patch update.
• Install/Upgrade SQL Server, SSRS, SQL Management Studio, SQL Data Tools in Virtual and Clustered Windows servers in all Test, Development and Production environments.
• Install monthly/quarterly Security patches and updates in all environments.
• During SQL Server migration follow ATO process, SQL Server enterprise documentation and follow BMC change request management process.
• Configure and maintain SSRS (Reporting), SSAS (Analysis) and SSIS (Integration).
• Creates Shared Data Source, Shared Dataset and reports using SSRS Business Intelligence Development Studio, Deploy to the report server and access the reports using web.
• Create Complex ETL Packages using SSIS (SQL Server Integration Services) to extract data from multiple sources into SQL Server Database. Develop, deploy, and monitor SSIS Packages.
• SSRS, SSAS and SSIS Installation, Upgradation and Maintenance. Troubleshoot and analyze user access issues.
• Database and Log Backups. Restore database. Audit log monitoring and review.
• Ensure database have High Availability and execute Disaster Recovery plan to bring back all the database online with minimal time.
• Create and maintain full or simple backup, database encryption keys and review SQL Audits.
• Free space and schedule jobs like Index Optimization, Cleanup database mail, Failed Job notification, Free disk Space check, Recycle error log, Login Lookup etc.
• Work closely with IT Security and Sys Admin team for SQL security findings.
• Co-ordinate with Sys Admin and apply Windows or SQL Security patch and notify business and application user.
• Provide all the evidences, Implementation detail and artifacts for all the control that comes under SQL Server continuous monitoring. Work with IT Security and OIS team for SQL Vulnerability scan and fix the issues.
• Work closely with Developers, Business users, IT Architect, IT Security, OIS, Assessment, Sys Admin, Network team to create and maintain documents like SSP, SQL Server Enterprise Cluster Installation Guide Database Engine, SQL Server Enterprise Solution Architecture / System Administration Manual / System Operation Manual / Secure SDLC Activities Project Timeline and System Diagrams.
• Create and maintain JAMS jobs. Migrate database and objects to new server.
• Create and maintain JAMS (Job Access & Management System) job. JAMS is a tool to provide additional notification options and new ways to execute Jobs. Use JAMS to FTP, SFTP, copy, delete and move files from different Operating systems.
• Migration Project - SQL Server 2008 R2 to SQL Server 2016.
• Developing and delivering a detail SQL Server database migration plan and Identifying the data migration impact of all proposed changes.
• Follow ATO (Authorization to Operate) process and work intensively with Development team, Business team, System Administration, IT Security and IT Security Specialist for SQL Server assessment and SQL Server migration. Provide all the evidences, Implementation detail and artifacts for all the SQL controls.
• Create and execute Post Installation T-SQL Script for database configuration setup, miscellaneous jobs, backup jobs, Audit, Temp DB File Creation, and Encryption.
• Understand new features in new SQL Server compared to Old SQL Server by following the Microsoft Document sites for SQL Servers. Create sold remediation or mitigation plan for the controls/components or tools that will not be any more usable in new SQL Server. And explore the new features that can be useful for the Client business.

SQL Server Database Administrator (SQL DBA)

Confidential

Responsibilities:

• Design, develop and maintain large-scale production and test databases including:
• Monitor Microsoft SQL Server databases.
• Create databases and tables on demand.
• Perform modeling and normalization.
• Install Microsoft SQL Server upgrades.
• Apply Microsoft SQL Server security profiles and manage user access.
• Perform backup and restoring routines consistent with Disaster Recovery Plan.
• Monitor database growth and perform capacity planning.
• Apply Microsoft service packs and security patches.
• Migrate servers and databases as new technology becomes available to customer.
• Develop and maintain complex stored procedures, functions, triggers and SSIS packages.
• Configure and maintain Microsoft SQL Server Reporting Services (SSRS).
• Monitor daily logs and security audits on all Microsoft SQL servers.
• Provide performance tuning and optimization of SQL queries.
• Import and export data into SQL Server from numerous sources (Excel, Access, Oracle, MySQL, etc.).
• Send and receive files using Secure FTP tools. Provide automation for multiple projects and various schedules.
• Assist developers in creating and supporting production applications.
• Coordinate with and provide information and as needed to DBA, IT personnel and management as requested by the client.

Project Lead - SQL Server

Confidential

Responsibilities:

• Design, develop and maintain large-scale production and test databases.
• Production Systems Management (PSM) of HCR (health care reform) projects. Handling onsite and offshore team.
• Implementation of APM tool for all PSM servers.
• Reviewing transition checklist as production assurance team and reviewing the development changes before any changes or turns moving to Production .
• Creating and modifying SSIS and DTS packages. Package deployment.
• Migration of DTS into SSIS packages.
• Creating and Maintaining SQL Server Agents Jobs.
• Converting SQL Agents Jobs to Dollar Universe Job.
• Code review and package review before moving to QA environment.
• Extensively involved in designing and maintaining the SSIS packages to export data of Excel spreadsheets and flat files sources to SQL Server Database.
• Optimization of stored procedures in SQL Server to improvise the speed of the application to display the data.
• Worked extensively in writing and analyzing complex stored procedures, triggers, Inner Joins, Outer Joins, Views.
• Weekly and monthly report to business which contain SLA tracking of tickets for acknowledgment, resolution etc.

Project Lead, Application DBA

Confidential

Responsibilities:

• Code review and package review before moving to QA environment.
• Extensively involved in designing and maintaining the SSIS packages to export data of Excel spreadsheets and flat files sources to SQL Server Database.
• Optimization of stored procedures in SQL Server to improvise the speed of the application to display the data.
• Monitoring the nightly job process during oncall support.
• Monitoring scrum team in Agile development process.
• Worked extensively in writing and analyzing complex stored procedures, triggers, Inner Joins, Outer Joins, Views.
• Solving Incident and Problem tickets with in SLA time.
• Weekly and monthly report to business which contain SLA tracking of tickets for acknowledgment, resolution etc.
• Worked as an Application DBA to monitor and take care of TEST, QA and Production servers (Monitored more than 20 servers).
• Worked with corporate DBA for migration of SQL Server from /2008.
• Communicate with Network team, Architecture team, Business, Corporate DBA to resolve the production issue.
• Have done database process improvement tasks like Job Rerun process, Low Disk Space alert process, Database blocking alert process etc.
• Implemented Job Rerun process which uses a windows utility through which a failed job can rerun without DBA intervention. This process is now being used by different projects to rerun the SQL Server jobs and the client managers highly appreciated for this tool.
• Optimization of Nightly EPT process. One of the optimization that recently done is optimized the nightly process to complete in 2.5 hours which was previously taking 5 hours to complete.

Module Lead/Developer

Confidential

Responsibilities:

• Attend daily scrum meeting and sprint planning meeting.
• Coding, Testing, Code review as per .NET and SQL Server coding standard.
• Coordinate with business for requirement clarification and present demo in every sprint/iteration/release.
• Coding and code review of complex stored procedures, Joins, views and user-defined functions.
• Write Complex stored procedure having dynamic queries.
• Designed and developed SSIS packages to extract, transform and load various data sources such as text files, CSV files, Excel spreadsheets and Oracle data into SQL Server 2005 for further data reporting and analysis.
• Performed various transformations on data such as Data Conversion, Conditional Split, Term Extraction, Execute SQL task, Bulk Insert, Merge and Union all etc.
• Implemented loggings in SSIS packages. File and Database logging.
• Scheduled jobs for executing the stored SSIS packages which were developed to update the database on daily basis.
• Scheduled the monthly/weekly/daily reports to run automatically onto the dashboard.
• Created and manage notification services to manage packages on success, completion and failure.
• Turn code to different environment TEST/QA/PROD using internal tool - Turn center Wizard.
• .NET RDLC report design and formatting. Designed complex web reports as per client requirement.
• Resolve UAT defects as per test cases and Warranty Incident tickets.
• Design Dundas chart for Dashboard reports.
• Update application handbook as per the implementation.

Senior Developer

Confidential

Responsibilities:

• Attend daily call with team member discussing about daily status.
• Coding, Testing, Code review as per VB .NET and SQL Server coding standard.
• Coordinate with business for requirement clarification.
• Coding and code review of stored procedures, Joins, views and user-defined functions.
• Designed and developed DTS packages to extract, transform and load various data sources such as text files, CSV files, Excel.
• Worked on creating test plan for the test automation
• Use of ListBox, Grid control, radio button and other controls for displaying data.
• Understanding the VB 6.0 code and converting the code into VB .NET code.
• Testing of both the applications (VB 6.0 and VB .NET) to verify the application is designed and working as per requirement.

Developer

Confidential

Responsibilities:

• Requirement gathering.
• Finalizing the specification document with the business user.
• Coding, Testing, Code review.
• Implementation of the software and the users.
• Write Stored Procedure, Views, User defined functions as per business rule.
• Creating tables, relationships, triggers and indexes
• Form designing, Database design.