SUMMARY:

• Confidential is a Microsoft Certified Database Administrator (MS SQL Server 2016/ 2014/ 2012/ 2008/ 2005/ 7.0 ) with extensive 18 years experience in the IT industry. His expertise lies in Project Management
• Service Management, installation, administration, troubleshooting, performance tuning, optimization, replication, clustering, always - on, logshipping, monitoring, back-up, High Availability, disaster recovery, data modeling, partitioning, data warehousing architecture, modeling, ETL, database platform, data profiling, performance tuning, physical infrastructure, strategic planning, business assessment, process design, knowledge management, extensive track record of successful projects and technical & financial analysis and maintenance of SQL Server databases in both clustered and stand-alone environments with a Storage Area Network (SAN-Tagma) on Windows NT/ 2000/ 2003 platform that lead to the growth of the organization.
• He has experience in migrating and upgrading SQL Server 2000/ 2005/2008/2012 to SQL Server 2005/2008/2012/2016 that helped organization to be in cutting edge technology. Confidential also has experience in
• SQL server development including data modeling (logical & physical design of databases), creating stored procedures, functions, triggers, cubes, reports, MDX and packages using T-SQL. He has excellent communication skills to be a great leader and lead the organization to interact with different clients/vendors .

PROFESSIONAL EXPERIENCE:

SQL DBA

Confidential (Philadelphia, PA)

Responsibilities:

• Using SSIS/MuleSoft/PowerShell, data is synced from Source to Destination/AWS depending upon Real-Time, Near Real-Time, Batch, Asynchronous transactions, Bulk data movement
• Integrations may involve in Reading data from Email/ File server, Encryption/Decryption of data/file, Orchestration, Staging data
• Implemented the TDE (Transparent Data Encryption) in all the Production servers to secure the employee personal data.
• Automated daily activities such as event log ids, running reports, deployments using Power shell scripts
• Maintained and monitored 300+ integrations using tools Foglight, DynaTrace
• Created C#, Python libraries to create Facades to establish connection to third party APIs
• Performed database administration tasks including maintenance, upgrades, user management, monitoring, audit and performance tuning
• Worked onAlways-On 2012and managed the Disaster Recovery and High Availability solutions.
• Setup/ implemented/ maintained/ troubleshootedAlways-On Availability Groupson a Multi-subnet failover network to enable mirror copies for reporting thus saving millions to the organization.
• Designed, developed, managed, and maintained all databases that support IIS, Web servers, development, testing and production operations
• Saved thousands of dollars to the Organization by designing, developing, testing, deploying and maintaining application servers (Tomcat) and number of inhouse applications such as Success Factor, HR Payment, Timesheet, Salesforce, SAP using Agile/ Scrum, Kanban process (Cherwell, Target Process, ServiceNow) by tuning legacy databases
• Evaluated, documented speed & bottlenecks
• Tuned T-SQL queries, Indexes, settings, configuration tweaks, hardware
• Load tested SQL servers
• Maintained best practices, policies, standards and protocols
• Dashboard saved additional server resources by both proactive and reactive tuning the performance of the SQL transactions
• Optimized in estimating SQL Server infrastructure and saved millions to Organization
• Automated the process to extract, transform, load, purge and clean data.
• Implemented partitioning to improve performance tuning on the database.
• Provide database support for OLTP and OLAP applications.
• Perform and improve data replication and purging operations
• Supported software development with database operations including storage optimization, database architecture/design guidance and integration for all relational databases, used by different 24/7 systems to store both customer and company provided data
• Worked with various teams to control and execute day-to-day database operations
• Developed strategies and implement solutions for database continuous testing, integration and delivery

SQL DBA

Confidential (Lockport, IL)

Responsibilities:

• Reviewed server infrastructure, disk, SQL server, configurations & counters
• Analyzed OS, SQL server performance and issues history
• Assessed and optimized server set up and usage user set ups and authorizations server components
• Deadlocks, Indexes, Stats, Disk and configurations
• SQL Database instances
• Analyzed performance counters statistics and recommended changes to server resources
• Saved thousands of dollars to the Organization by tuning legacy databases
• Evaluated, documented speed & bottlenecks
• Tuned T-SQL queries, Indexes, settings, configuration tweaks, hardware
• Maintained best practices, policies, standards and protocols
• Improved performance by recommending to move reporting activities (Jobs, adhoc ) to another server using replication at SAN/SQL.
• Immediate performance improvement
• Separating data files from log file
• Creating more data files on another drive
• More data files for TempDB (SQL 2016 supports creation of more datafiles during installation)
• Maintained Zuora to run recurring revenue to align commerce strategy, keep up with recurring bills and collections, and manage recurring revenue
• Consolidate report of long\frequently running jobs/queries and tuning them based on criticality and priority.
• Assembled overall assessment and recommendations documentation and roadmap

SQL DBA

Confidential (Charlotte, NC)

Responsibilities:

• Design, develop, implement, maintain and administer data schemas for 40 TB database
• TO support latest cutting technology, migrated from SQL to
• Saved additional server resources by both proactive and reactive tuning the performance of the SQL transactions
• Made sure projects rollout in time by promptly troubleshooting the database and connectivity issues in time sensitive situations
• Supported release rollouts for application teams, demonstrating client management skills and a comfort with change management concepts.
• Provided support to project teams utilizing time management skills and exercising judgment of when to escalate issues to leads and management.
• Extensively worked on setting upAlways On Availability Groupson a Multi-subnet failover network.
• Worked along with the Windows team to configureWindows Failover Clusteron which the Always-On setup was done.
• Most of the critical production servers are in cluster environment for high availability
• Designed, developed and maintained BOFA’s different functionality packages to load weekly data into the database.
• Validated and tested ETL packages using QA script, XML, JSON for redundant implementation of the business rules
• Interacted with stockholders to gather requirements for the project
• Written, interpreted Data Mapping, Software requirement specification, Work product requirement and Bridging documents.
• Implemented database backup strategy using Litespeed tool
• Development and performance optimization of database objects including partitioning schemes, indexes, functions, triggers, stored procedures, and CLR objects.
• Troubleshooted performance issues, follow-up with Microsoft support and fine-tuning queries & stored procedures for SQL Server 2005/2008, Policy Based Management and SOX audit.
• Implemented partitioning to improve performance tuning on the database.
• Provide database support for OLTP and OLAP applications.
• Provide guidance for BI best practices.

SQL Architect

Confidential (Austin, TX)

Responsibilities:

• Driving EdFi project which is vendor-neutral, open, XML-based and designed to integrate information from a broad range of existing sources.
• Implemented following applications using EdFi
• Ed-Fi standard
• Ed-Fi solution
• Ed-Fi dashboards
• Ed-Fi ODS
• Analyzed EdFi historical data received from Student Information System (SIS PeopleSoft Campus Solutions) or HR, revisit schools with a prototype and gather more requirements.
• Verified EdFi historical data in-terms of data validity, orphan data etc.,
• Created XML files, loaded Operational Data Store into Dashboard Data Source using ETL packages.
• Mapped XML file to have a single component process multiple input files of a directory and output multiple files to a single component using Altova Mapforce
• Validated ETL packages using QA script for redundant implementation of the business rules
• Prevent data corruption and data redundancy using Sanity check scripts
• Performed ETL unit testing before handing it over to QA team
• Metadata testing
• Created tests using Test Data Manager
• Test Runner for running the tests created and common problems encountered
• Owned optimized and prioritized the intake from the EdFi BI demand for the reporting and analytics across the Enterprise Services in alignment with the business strategies and priorities. Articulated the value proposition and drive prioritization.
• Architected tables using Kimball’s architecture
• Identified dimension and fact tables to build cubes
• Developed reports to display data in Excel, SSRS.
• Maintenance of SQL technologies like Replication, Clustering, Database Mirroring
• Migrating SQL 2005, SQL 2008 R2 to SQL 2012

SQL Lead

Confidential (Baton Rouge, LA)

Responsibilities:

• Contributed in the growth of the company by driving following projects focused on new data initiatives for real-time decisions, reporting, and ad-hoc analyses
• Health System of Illinois
• Health System of Mississippi
• Health System of Florida
• URUM
• Care Co-ordination
• Predictive Modeling
• Implemented SQL\MYSQL security to avoid any project related access issues.
• Implementing best practices, Installing, Managing and administering MYSQL, SQL 20 database engine, Analysis server(SSAS), Reporting server (SSRS), windows batch scripts, VB scripts, C# and Integration Services (SSIS) on clustered production instances with high availability.
• Created a successful master data management project while working along with the stakeholders to generate acceptance and ownership go a long way
• Normalized databases to be accurate, fast and efficient and produce the data more than company expected and saved billions of dollars on different projects.
• Saved high profile project by implementing best practices, troubleshooting performance issues and fine-tuning queries and stored procedures for SQL Server 2005/2008/2012.
• Supported company to be on cutting edge by migrating SQL 2008 to SQL 2012.
• Experience in usingSSIStools like Package Installation, and SSIS Package Designer and Import and Export Wizard/ BCP between different sources like Oracle/Access/Excel.
• Experience in developing, deploying and administering SSIS packages across all environments.
• Expert in generating writingparameterized queries, drill through reports andformatted SQL server Reportsin SSRS 2005/ 2008/2012 using data from ETL Loads, SSAS Cubes, Cognos and various heterogeneous data sources.
• Definingdata warehouse(star and snow flake schema), fact table, cubes, dimensions, measures usingSQL Server Analysis Services.
• Installing, Managing, Troubleshooting and performance tuning MySQL (5.0.22 and 5.1.24) in production and non-production environments
• Effectively configured MySQL/SQL Replication as part of High Availability solution.
• Development and/or maintenance of very large-scale Data Warehouse applications with various data sources including SQL Server, Sybase, MS Access, Excel Oracle, Informix, Flat Files.
• Data Architect\Modeling OLTP and OLAP environments.
• Owned optimized and prioritized the intake for the BI demand for the reporting and analytics across the Enterprise Services in alignment with the business strategies and priorities. Articulated the value proposition and drive prioritization.
• Experience in managing 46 TB of database.
• Writing SQL and T-SQL queries, stored procedures, and triggers.
• Provide team of analysts and developers technical guidance and challenges aligned with career development paths
• Participate in strategy discussions, analysis and decision making by providing stakeholders with technical input and recommendations.
• Continuously keeping an eye on the latest cutting edge technologies and leveraging these in one's own work

Manager Delivery

Confidential (NYC)

Responsibilities:

• Developing, Managing & executing various IT projects at Artio Global
• Eagle Uploader
• Daily Price & Security flow from Bloomberg, NTRS, Factset to Eagle & Charles River.
• Bloomberg Data migration into Symantec Enterprise Vault (Journals, emails, BB etc.)
• Bloomberg Historical Data Management & Migration to Enterprise Vault
• Core Infrastructure UpgradeWin2K8 Server
• Virtualization: ESX3.0 to 3.5 & ESX 3.5 to 4.0
• Good Technology Rollout for User Owned Handhelds
• DB Schema refresh
• Onsite offshore co-ordination
• Service Management (ITIL 3.0 Frame-work)
• Client interaction and only SQL manager for the delivery unit handling 15 resource.
• Installing, Managing and administering SQL 2005/2008/2012 database engine, Analysis server(SSAS), Reporting server (SSRS) and Integration Services (SSIS), Informatica on clustered production instances
• Monitored SQL server and Windows Server performance using “Performance Monitor” tool.
• Created stored procedures, triggers, indexes in SQL 2005/2008/2012 environments using T-SQL.
• Migrated from SQL .
• Datacenter DBA Tower to make transparency of the issues and concepts of the process.
• Designed SSISPackagesto transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Configured Secure Shell (SSH) to connect client to SQL server through firewall.
• Troubleshooted performance issues and fine-tuning queries and stored procedures for SQL Server 2005/2008, Policy Based Management and SOX audit.
• MySQL database administration on a large scale MySQL installation.
• MySQL database backup and recovery strategies and Replication and synchronization.
• User management by assigning appropriate permissions to the database users SQL Server 2005/2008.
• Backup using Idera.
• Database session management like identifying problem sessions and tracing them using profiler, PSSDIAG and other Microsoft utilities.
• Analyzed query plans to tune SQL Queries. Writing SQL scripts for gathering statistics for performance-tuning benchmarking.
• Made recommendations for space management and monitoring.
• Monitor, set and control system capacity plan for future system requirements.
• Worked with other technical teams to resolve performance issues.
• Patch Management - Tested Hotfix/Service packs/Builds of Ms SQL server before applying to business environment.
• Tested database mirroring (DBM)

SQL Server Consultant

Confidential (NYC)

Responsibilities:

• Managed and administered SQL databases
• Monitored SQL server and Windows Server performance using “Performance Monitor” tool and using SQL scripts.
• Installed SQL DB engine, Integration services, Reporting services & Analytical services.
• Toubleshooted issues experienced during installations.
• Provided BI platform to analyse and send reports to higher management

Lead Database Administrator

Confidential

Responsibilities:

• Data Warehousing
• Risk Assessment Program
• SQL 2005 Migration
• Database Migration
• Clustering Technology
• Logical Database
• TestDB Refresh

Database Administrator

Confidential

Responsibilities:

• MCare Claims Processing & Administration Modules
• Member Enrollment Module