SUMMARY

• Experienced Microsoft SQL Server consultant with 20 years of IT experience in Database Migration and Administration, Architecture, Development and Amazon AWS Schema Conversion Tool migration management,.
• Being Data Analyst and Database Designer, reflecting the emergence of Internet Web Sites which need to integrate data from different unrelated Data Sources. Data flows through the successive stages involved and address issues of Data Migration (Validation, Clean - up and Mapping), and will need to understand the importance of Data Dictionaries.
• Solid experience of managing databases through version control across all environments, especially the schema discipline.
• Proven Experience in Database Migration from MS SQL server 6.5-7.0-2000-2005-2008-2012-2014-2016.
• Experience in Implementing, Upgrading, Migrating to SQL Server from versions 2005 up to version 2016 and SQL Server on Azure virtual machines
• Solid experience in developing variety of proof of concepts for SQL Server features testing and future implementations specific to the existing environments and limitations.
• Solid experience in maintaining and validating data sync between source and Report server(s).
• Experience in deploying, SharePoint databases and configuring high availability for the same using AlwaysOn.
• Configured HA for SharePoint databases using either Peer-to-Peer replication, Mirroring, AG and Log-Shipping.
• Implemented AlwaysOn availability groups and replicas for reporting, backup and performance
• Expert in managing SQL Server in Physical and Virtual Environments.
• Experience in implementing different types of Replication topologies involving Snapshot, and Transactional replication.
• Expert in SQL Server Clustering, implementing Active/Active and Active/Passive clustering
• Expert in monitoring SQL Server with Diagnostic Manager, FOGLIGHT tools and native tools
• Expert in Installing and configuring SQL Server Cluster in Active/Passive and Active/Active environments.
• Implemented MIRRORING for Disaster Recovery Implementation
• Expert in using Ticketing and Change Management software.
• Perform the installation of SQL Server patches and upgrades on various versions.
• Performing Windows server setup with database server setup along with backup and restore activity using defined storage.
• Performing Automated tasks for jobs reports and failover automated activities to manage system with minimal resource support.
• Experience in implementation of Infrastructure with best practice and ability to handle multiple IT projects and Team.

TECHNICAL SKILLS

Database: SQL Server 6.5/7/2000/2005/2008/2012/2014/2016 , Azure SQL, DB2, Oracle, PostgreSQL 9/9.1/10

Database Tools: Amazon AWS Schema Conversion Tool, Enterprise Manager, SQL profiler, SSDT, BI Tool SSIS, SSAS,SSBS, Data Warehouse, Erwin Data Model

Reporting tools: SSRS, Crystal Reports and Microsoft Reporting Server

SQL server Tools: SQL profiler, Microsoft Reporting Server, MS Visio and XML, LightSpeed

Application tools: Light Speed, Idera RedGate, Quest Foglight, NetBackup, Scrum Master Rally Tool,Jira

Monitoring Tools: Derdack Enterprise, SCSM, LANDesk, Foglight BMC, IDERA SQL DM, SolarWind, Sentry

Operating Systems: Windows 2016/2012/2008/2003/ Win7/XP/2000/NT/98/97/95, DOS/ Unix/Solaris/AIX/Linux

Method &Technologies: Prince2, Agile, Waterfall, Enterprise App management/Tablet/Mobile Apps

Languages: Visual Fox Pro, Visual Basic, PowerBuilder, C++, C, T-SQL, SQL

Framework: MS.NET

Middleware: Web Services

Client/Server Tools: VB, Sybase PowerBuilder, MS.Net

Web Tools: ASP.net, HTML, IIS

Other Tools: HA Always On, VMware, IDERA SQL JOB MANAGER, Lotus Notes, VSS/TFS, JIRA, AccountMate, Epicor, Rally

PROFESSIONAL EXPERIENCE

Confidential

Lead DBA

Responsibilities:

• Performing exploratory data analysis, querying database, and data integration with SQL Server and Amazon Aurora PostgreSQL for Data Analysis and interpretation.
• Build features containing measurement of trend, periodicity, skewness, nonlinearity, and self-similarity.
• Create and validated the model for the database conversion from SQL to Amazon Aurora PostgreSQL.
• Develop risk prediction model to make recommendations for reducing risk.
• Develop Model layer: feature engineering, use of aggregated features grouped by factors and their combinations.
• Build model output, summary statistics.
• Used DBeaver, pgAdmin and AWS Schema Conversion Tool for migration of Schemas, Stored Procedures, functions, indexes and views based on mapping fields with code review for team.
• Ensure all software products, applications and data met the highest possible quality standards by following industry recognized Agile methodologies and best practices.
• Amazon Data Migration Service to perform extensive data flow in Source, Staging, tables, for application and reporting databases from SQL Server to Amazon Aurora PostgreSQL.
• Develop the migration analysis documents, migration strategy document, test case and test result document for end to end migration for the following activities of Deliverables for migration:
• Analysis of databases for suitable target disposition which would be AWS RDS or AWS EC2 considering limits of RDS PostgreSQL.

Confidential

Lead Engineer-Database PM

Responsibilities:

• Perform exploratory data analysis, querying database, and data integration with SQL Data Analysis and interpretation.
• Evaluate different machine learning algorithms.
• Build features containing measurement of trend, periodicity, skewness, nonlinearity, and self-similarity.
• Create and validated the model.
• Develop risk prediction model to make recommendations for reducing risk dealer score.
• Develop Model layer feature engineering, use of aggregated features grouped by factors and their combinations.
• Build model output, summary statistics.
• Develop ETL stored procedures, SSIS mapping and merge processes along with code review for team.
• Used SQL Server Service broker for managing the messaging system and improving performance for frontend databases supporting websites can record information and send process intensive tasks to queue in back-end databases.
• Ensure all software products, applications and data met the highest possible quality standards by following industry recognized Agile methodologies and best practices.
• Perform extensive ETL data flow in Source, Staging, warehouse Fact and Dimension tables, Data Mart field using MS SSIS.
• Performing troubleshooting based on validation results.
• Mentor team for writing SQL Queries to ensure data quality and data integrity for Back-end to follow best practice and process based on Scrum using Rally tool for story’s defined based on the project requirements.
• Develop automated conversion and migration methods.
• Continuous Integration with deployment automation.
• SQL Server Business Intelligence (BI) tools for data integrations from different database servers.
• Build releases for development, QA and production environments for new user stories and backfill of data based on the project requirements.
• SSDT tool for data integration projects related with database migration and including recursive changes.
• Mange implement and optimize the performance by database model changes required for different projects used as per need.
• T-SQL for making frequent changes as per business needs to fix ongoing issues for the releases.
• Perform daily monitoring and administrative tasks for all production Business intelligence related SSIS packages.
• Assist in database architecting for database systems development, management, and administration and modeling of business applications.
• Establish database structures and support development, and implementation using SSIS integration services and SSDT.
• Database Problem support and change control for proper script development deployment in sequence.
• Optimize database performance through proactive maintenance.
• Perform database tuning, monitoring, and database security administration.
• Ability to manage EDW and services related to data analytics such as ETL process.
• Working with multiple Teams and vendors as single point of Contact for new database related project being Lead Engineer for Database and BI assigning and mentoring team as per requirement based on the projects and planning.
• Database management for the production environment for BI Integration and migration projects Oracle to SQL and SQL to Oracle using linked servers.

Tools: Used: Scrum Master Rally, Business Intelligence SSIS, SalesForce, MS SQL Server 2012/2016, MS Visual Studio.Net 2017, Oracle, AWS S3,Data Integration, SSDT, PostgreSQL

Confidential

Senior DBA Manager

Responsibilities:

• Managed database servers on AlwaysOn for SQL Server 2014, 2016 and clustering for SQL Server including version from SQL 6.5/ 7.0/2000/2005/2008/2012/2014/2016 .
• Used SQL Server Service broker for managing the messaging system to reduce development and test work as it handles communication paths in the context of conversation.
• Used T-SQL to compare different table data of source and destination to confirm the sync as per DATA WAREHOUSE needs.
• Used T-SQL to check the duplicate insertion of records and eliminate using automated programming process.
• Used SQL to check SQL agent job tables for sys tables in MSDB for dbo schema.
• Used SQL to perform and check database health including tables locked by user and checking active sessions.
• Scripted tables to get definition of tables and alter tables based on the need.
• Recreated Indexes and rebuild indexes based on the requirement with update stats for performance enhancement.
• List of table names, views, user’s status and several task done to get automated job report which can be used by business users.
• Procedural programming using T-SQL
• Local variables handling using T-SQL
• Various support functions for string processing, date processing using T-SQL
• Used T-SQL for Changes to the DELETE and UPDATE statements so that they allow a FROM clause to be added which will allows joins to be included.
• Used T-SQL has it has a BULK INSERT statement that allows you to import a data into a database table or view in a user-specified format faster specially used during BI tools SSIS package performance optimization.
• Used joins to get required data from the tables based on the business requirement.
• Database management and maintenance for Postgresql 10.0
• Script deployment on Posgresql for the latest structure updation and amendment of required changes.
• PostgreSQL Database version migration from 8.5 to 9 to 10.0 version and making sure schema gets updated properly.
• Database Administration and implementation of Managed Audit database servers HR data and CRM application with SSIS package creation and fixing for integration automation in several verticals.
• Lead team of Database engineers for providing core infrastructure services to business in a large complex environment.
• SQL Database Server Configuration and management for production servers.
• Managed database servers driven by Systems Operations and other IT & Business Groups.
• Managed applications and databases as per IT Architecture and SDLC.
• Implemented environment for data integration from Oracle database to SQL Server Databases and managed several jobs of SQL Server including High availability and SQL clustering environment.
• DBA/Architect and acting as Business Intelligence solution provider for application system and validation verification related with different systems.
• Hands-on leading projects related with Transaction Solutions and giving on prompt support with almost zero downtime for their application software.
• Involved in BI SSIS package development and implementation for legacy data migration and also for transactional data as per client requirement.
• Optimization of Database server with regular fine-tune and providing custom solution based on Client data requirement with Authorization approval using SSIS integration BI system.
• Custom code management and Tracking the tickets based on priority.
• Working and managing team of .Net developer, Infrastructure team and database team including database developer management based on delivery requirement.
• Project management for applications with Data integration using SSIS migration for data and database structure from legacy to new system related management with Authorization encryption level.
• Application project management using Agile Methodology for applications with SQL Server and Oracle Database Servers as backend.
• Worked on RBS for OneDrive and iOffice for SharePoint configuration with Drive encryption as per security requirement for file stream.
• Managing vendors in client for SharePoint developers and Database developers for getting the requirement fulfilled based on the project migration and new project assignments.
• Performance analysis and load management based on Always On technology of SQL Server for balancing the load and having High Availability for all SharePoint Databases in synchronized mode for load balancing with read-only and read write wherever needed.
• Managing Database growth for SharePoint databases and application databases.
• Working with multiple Teams and vendors as single point of Contact for new database related project being Senior DBA Manager and assigning and mentoring team as per requirement based on the projects and planning.
• Database management for the production environment for BI Integration and migration projects Oracle to SQL and SQL to Oracle using linked servers.

Tools: Used: Business Intelligence SSIS, MS SQL Server 7.0/2000/2005/2008/2012/2014/2016 , HA Always ONMS Visual Studio.Net 2015, Oracle, SSDT, LANDesk, SolarWind,PostgreSQL 8.5/9.0/9.1/10.0

Confidential

Senior DBA Manager

Responsibilities:

• Senior DBA for IT Auditing enterprise application management on SQL and Azure Database Servers.
• Managed database servers on AlwaysOn for SQL Server 2014.
• Implemented environment based on FCI and Data Protection Management for SQL Databases.
• Managed Audit database servers for Microsoft dynamic CRM application and SSIS package creation for CGI project for integration automation.
• Managed team of system engineers for providing core infrastructure services to business in a large complex environment.
• SQL Database Server Configuration and management for production servers.
• Managed projects such as driven by Systems Operations and other IT & Business Groups.
• Managed applications and databases as per IT Architecture and SDLC.
• Used T-SQL to compare different table data of source and destination to confirm the sync as per DATA WAREHOUSE needs.
• Used T-SQL to check the duplicate insertion of records and eliminate using automated programming process.
• Used SQL to check SQL agent job tables for sys tables in MSDB for dbo schema.
• Used SQL to perform and check database health including tables locked by user and checking active sessions.
• Scripted tables to get definition of tables and alter tables based on the need.
• Recreated Indexes and rebuild indexes based on the requirement with update stats for performance enhancement.
• List of table names, views, user’s status and several task done to get automated job report which can be used by business users.
• Used joins to get required data from the tables based on the business requirement.
• Used Object catalog views and Information Schema.tables and Information Schema.Columns to get the required data with sys.extended properties.

Tools: Used: Business Intelligence SSIS, MS SQL Server 2014, HA Always ON, SSDT, MS Dynamic CRM

Confidential

Senior Consultant

Responsibilities:

• Worked as Senior Consultant for Databases and Enterprise Implementer using Foglight Application including Databases and application support for all production servers related with business also actively involved in managing and implementing SQL Server and oracle servers for Windows, Unix, Sun Solaris and AIX operating systems.
• Sr. DBA and Implementer for tools and automation including Experience in migration of Foglight version including
• Database and application upgrades from 5.6.10 to 5.7.1 to5.7.5.5.
• Used T-SQL to compare different table data of source and destination to confirm the sync as per DATA WAREHOUSE needs.
• Used T-SQL to check the duplicate insertion of records and eliminate using automated programming process.
• Used SQL to check SQL agent job tables for sys tables in MSDB for dbo schema.
• Used SQL to perform and check database health including tables locked by user and checking active sessions.
• Scripted tables to get definition of tables and alter tables based on the need.
• Recreated Indexes and rebuild indexes based on the requirement with update stats for performance enhancement.
• List of table names, views, user’s status and several task done to get automated job report which can be used by business users.
• Used joins to get required data from the tables based on the business requirement.
• Used Object catalog views and Information Schema.tables and Information Schema.Columns to get the required data with sys.extended properties.
• Tools Used: MS SQL Server 2012\2014, SSRS, Dell Quest FogLight, SolarWind, Linux, Solaris, AIX, Oracle RAC Databases