PROFESSIONAL SUMMARY:

• Overall 16 years of IT experience as Intuitive Data Architect/Lead Server DBA/ETL&BI Developer with proven experience in designing High Availability database systems, review, evaluate and optimize database systems with diverse technologies using MSSQL Server, Tera Data, Ab Initio, Qlik View, Power BI in Banking, Financial, Insurance, Logistics, Education sectors
• Create, deploy, and manage the data architecture
• Implement standards and best practices for data architecture and make sure developers are compliant with those standards
• Expertise in data models, ER diagrams, conceptualize entity relationship models from logical to physical implementation
• Exposure to Status reporting to Senior Executive management by working/coordinating multiple teams
• Expertise in People Management, Team - building, Co-ordination, Innovation and Techno-Functional skills
• Good experience with different versions of SQL Server database features for Production and non-production
• Experienced in configuring, supporting and troubleshooting high availability solutions such as Microsoft Cluster Services, Logshipping, Database mirroring and Replication topology
• Very strong DBA skills such as backup and disaster recovery, performance monitoring and improvements & daily preventive maintenance of multiple SQL Servers on Windows 2000/2003/2008 Servers
• Experienced in Tuning and optimization of SQL queries and stored procedures using SQL Profiler and Performance monitor and ensuring indexes are using updated statistics
• Expert in Install and uninstall process of SQL server using automation methods on Virtual and Physical environment
• Expertise in setting up the DBA environment, documenting build and deployment processes for SQL databases
• Lead implementation of security policies, procedures, and best practices for RDBS across the enterprise
• Has proven track record of successfully executing IT initiatives that supports critical Business processes
• Experience in streamlining a big program, 24 X 7 and managing a 20+ team size spread across multiple locations
• Expertise in Installing, Monitoring and Troubleshooting MSSQL Server 2000/2005/2008/2012/2014/2016
• Experience with Database Backup, Recovery and Disaster Recovery procedures
• Proficiency in high availability SQL Server solutions including Clustering, Always On, Log shipping, Mirroring, Replication
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, SQL Profiler
• Strong knowledge in ETL and BI (SSIS, SSRS, SSAS, DTS, Ab Initio and Qlik View, Power BI Dashboards)
• Provided custom training for Junior DBAs
• Well versed in Rational Rose, Visio, UML Modeler, ERWin, TOAD and SDLC methodologies Agile, Waterfall

TECHNICAL SKILLS:

Operating Systems: Win 2K, 2003 Server, 2008 Server, Win 95/XP/Vista/8/10

RDBMS: MSSQL Server 2016/2014/2012/2008/2005/2000 , Tera Data, Microsoft Dynamics

DBA Tools: Remedy, Lite Speed, Alarm Point, Patrol, Red Gate, Fresh Service

ETL/BI Tools: SSIS, SSAS, SSRS, DTS, Ab Initio, QlikView, Power BI

Languages: T-SQL, C, C++, Java, VB, J2ME

Modeling Tools: Visio 2000/2003, UML2.0, Rational Rose 98/2000, ERWin, TOAD

Version Control Tools: TFS, Visual Source Safe, Rational Clear Case, Star Team

PROFESSIONAL EXPERIENCE:

Lead Database Administrator

Confidential, TX

Responsibilities:

• Partner with various business stakeholders and technology leaders to translate program requirements into scalable technical solutions and system designs
• Research, design, test, and evaluate new technologies, platforms and third party products
• Production support, capacity planning, hardware planning and configuring SQL server instances on Windows environment
• Involved in designing and building new SQL Server environments with appropriate performance parameters
• Report generation for CIO on weekly basis
• Monitor and maintain multiple SQL Servers 2014, 2008 R2, 2008 databases in Production and QA Environments
• Involved in backups and recovery of SQL server troubleshooting any failures or alerts from Servers
• Implementing and maintaining database security policies
• Involved in SQL Scripts development
• Involved L2 and L3 production support for many critical applications
• Installing SQL Server 2014, 2008 R2
• Documenting the Standard Operating Procedures
• Involved in setting up Reporting services, Integration, Analysis services in SQL Server 2014/2008 R2 and maintaining of SSIS/SSRS packages in SQL Server 2014/2008 R2
• Involved in security management, performance tuning, file group management, disk space management
• Helpdesk Support using Fresh Service
• Expertise in Migration and Upgrades of different versions of SQL Server
• Training, Development, Deployment and Maintenance of ETL and BI using SSIS, SSRS, Power BI
• Monitoring Server Health using Logic Monitor and 24x7 on call support

Confidential, NJ

Data Architect\Lead MSSQL Server DBA

Responsibilities:

• Lead data modeling sessions and create enterprise data models
• Evolve and introduce new data management standards and best practices for enterprise-wide data architecture
• Analyses current state data design while conceiving future state and proposes projects to realize
• Develop ETL and BI solutions to enable data migration
• Instrumental in the gradual increase of the team-size & revenue for the account
• Handle a team of approximately 20 resources
• Ensuring service delivery as per contract / SLA for all the DBA
• Providing reports on a daily, weekly, monthly basis as per requirements
• Client Interaction & Bridging the gap between the customer and team
• Introduce site-specific customer satisfaction improvement initiatives based on customer feedback
• Implementation of best practices and ensuring closure of Audit actionable as per standards
• Production support for SQL Server 2000, 2005, 2008 and 2012 databases
• Implementing and maintaining database security policies
• Applying the SQL Scripts on Test and Production
• Regular maintenance of Backup and Recovery from Production to Development and Testing
• Running Database Consistency Checks, Shrinking of Log files using DBCC
• Installing Client tools of SQL Server 2005 on different user machines
• Documenting the Standard Operating Procedures
• Clearing Remedy Tickets (HelpDesk Support related to Data problem for Application users)
• Migration from SQL Server 2000 to SQL Server 2005, 2008, 2012
• Maintaining SSIS, DTS packages and scheduled Jobs
• Work directly with business units to define and prototype QlikView Applications
• Extracting, transforming and loading data from multiple sources into QlikView applications
• Working in 24x7 on call support environment

Confidential, IN

Project Lead/Lead MSSQL Server DBA/BI Programmer

Responsibilities:

• Team coordination and work allocation to team as a Project Lead
• Work status reporting to Managers
• Involved in resource hiring process
• Installation of MS SQL enterprise servers on test and development boxes
• Performed Data Migration from MS SQL 2000 to 2005
• Implemented and maintained Log Shipping, Mirroring, Replication
• Working in 24x7 on call support.
• Monitoring various Jobs, Task Management and Reconciliation Process
• Trouble shooting the issues incurred while executing the Jobs
• Managing the Veritas net backups
• Documenting the Standard Operating Procedures
• Clearing Remedy Tickets (HelpDesk Support related to Data problem for Application users)
• Implementing Disaster Recovery procedures.
• Creating and monitoring the user accounts, creation of groups, granting the privileges to users and groups
• Database and Log Backups & Restoration, Backup Strategies, Scheduling Backups.
• Perform capacity planning in collaboration with Developers, Administrators and System Architects
• Analysis, Design, Development and Maintenance of Dashboards using Qlik View
• Installation of Qlik View Clients and Managing QlikView user accounts
• Perform DBCC commands for database consistency

Confidential, NC

Team Lead/MSSQL Server DBA/ETL Programmer

Responsibilities:

• Work allocation to Team and status reporting to Managers
• Trouble shooting the issues incurred while executing the Jobs
• Administering the Backup, Recoveries on different environments
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Used DBCC commands to troubleshoot database issues
• Administered the MS SQL Server for the Users with appropriate Roles
• Performance Tuning and Normalization of database
• Monitoring SQL Server activity through Profiler
• Design & implementation of Stored Procedures and Triggers for automating tasks
• Dropped and recreated the indexes on tables for performance improvements
• Planned and tested processes for both backup and recovery.
• Experience in Design, Development and Test of Ab Initio graphs
• Used the EME as the source code repository performing check-ins and check-outs from and to the sandbox
• Imported various Sources and Targets using Ab Initio to create Mappings for various Business scenarios

Confidential, VA & NY

MSSQL Server DBA

Responsibilities:

• Administering the Backup, Recoveries on different environments
• Used DBCC commands to troubleshoot database issues
• Administered the MS SQL Server for the Users with appropriate Roles
• Performance Tuning and Normalization of database
• Monitoring SQL Server activity through Profiler
• Design & implementation of Stored Procedures and Triggers for automating tasks
• Implemented and maintained Replication for Check Printing and Trading Modules
• Fine tuned Stored Procedures and carried performance improvement on long running queries
• Dropped and recreated the indexes on tables for performance improvements
• Planned and tested processes for both backup and recovery
• Worked on DTS Package designs for Import/Export from various Data
• Provide 24 X 7 dedicated support to all Production, QA & Development MS SQL Server Environments