PROFESSIONAL SUMMARY:

• Over 12+ years of IT experience in SQL Database Administration , System Analysis, Design, Development & Support of MS SQL Servers 2016,2014, 2012, 2008,2008R2, 2005 and 2000 in Production, QA and Stage.
• 5 + years of experience as MSBI(SSAS/SSIS/SSRS) Developer and Data Analyst using OLTP/OLAP/BI environments along with around 1 year of data visualization using Tableau and Azure .
• Experience in T - SQL, SQL Server Integration Services ( SSIS ) and SQL Server Reporting Services ( SSRS ), Tableau Reporting with good knowledge on SQL Server Analysis Services ( SSAS ).
• Experienced in all phases of BI full life cycles including analysis, design, development, testing, deployment, post-production support/maintenance , documentation and end-user training
• Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2016, 2014, 2012, 2008, 2005 .
• Experience in SSIS ETL packages designing and development for various complex solutions including files processing, Incremental loads, and historical data maintenance. Extensively used Configurations, Logging, debugging using breakpoints, and Check points, Transactions, Error and Event Handling.
• Involved in huge data migrations, transfers using utilities like Data Transformation Services ( DTS ), and SSIS , Bulk Copy Program ( BCP ) and Bulk Insert.
• Experience in design and development of various user stories, dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions and filters.
• Skills in Oracle Database Administration .
• Providing L3 Production support.
• Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues.
• Experience in BI Development and Deployment of DTS , SSIS packages from SQL Analysis Server, Teradata, MS-Access, Excel, and Oracle.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Query Optimization and Performance Tuning .
• Excellent in DTS and SSIS package development and implementation.
• Experience in Incident and release management team.
• Possess 6 years of experience in Database Design, Administration, Implementation , and Application Development .
• Extensive knowledge of Relational Database Management Systems.
• Good experience with implementing DR solution, High Availability of database servers using Database Always on and Mirroring and Replications and Log Shipping .
• Experience with Database Backup and Recovery procedures.
• Experience in Migrating 2005 and /2014 server.
• Experience with DTS and SSIS
• Experience with AWS Cloud .
• Experience with data visualization using Tableau .
• Experience with T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers and good knowledge in performance tuning .
• Designed and developed various SSIS packages ( ETL ) to extract and transform data and involved in Scheduling SSIS Packages.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis using SQL Server Agent.
• Developed ETL packages with different data sources ( SQL Server, Flat Files, Excel source files, Oracle, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created reports using In Power BI reporting tools.
• Experience in MS SQL Server configuration , performance tuning , client/server connectivity, query optimization , back-up/recovery , running Database Consistency Checks using DBCC .
• Experience in implementing different types of Replication Models like Snapshot , Merge and Transactional on basis of business specification.
• Experience in performing integrity checks . Methods include configuring the database maintenanceplan wizard and DBCC utilities.
• Experience in troubleshooting SQL issues by using SQL Tools , execution plans , Trace , statistics , index tuning wizard.
• Experience in using Performance Monitor , SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
• Implemented customized log shipping for SQL Server 2012 and built in log shipping with SQL
• Server 2016/2014/2012 , 2008 and 2005 .
• Hands on experience in Troubleshooting database issues.
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using
• SSIS , BCP and DTS utility. Extracting, Transforming and loading of data using SQL Server DTS and SSIS .
• Design and document Logical and Physical data models.
• Applying SQL Server Service packs and Hot Fixes.
• 24 X 7 Production Database On Call Support .
• Designing and documentation of SQL Server Strategies and plans.
• Experience in supporting Large Databases up to a size of 2 to 3 Tera Bytes.
• Data migration using DTS services across different databases like Oracle and flat files.
• Automating the Database Maintenance tasks by creating Jobs and Alerts.
• 24x7 Support including scheduled and emergency night and weekend work.
• Good interpersonal, Analytical and Communication skills.
• Experience in using third party tools like Litespeed , Idera SQLDM and Lime Inventory .
• Excellent in ITIL process.
• Effective people management, Ability to ensure meet customer expectations with acceptable quality.
• Creative thinking and ensuring streamlining of the process and functions.
• Excellent working skills on Microsoft office tools.
• Monitoring calls, assigning the calls to the respective customer support engineer.
• Root causes Investigation.
• Best Man power utilization, Customer satisfaction

TECHNICAL SKILLS:

Primary Skill category: MS SQL Server 2000/2005/2008/2012/2014 and 2016, Oracle 11g,12

Operating Systems: Windows 2000/2003/2008 and 2012 /XP/LINUX

Database Tools: SQL Server Management Studio, BIDS, SSDT, SSIS(ETL), SSRS, SSAS(OLAP), Tableau Desktop 10.0, Performance Monitor, Query Analyzer, Query Optimizer, SQL Profiler, Data Transformation Services (DTS), Bulk Insert and BCP, ODBC

DBA: Oracle

SQL, Transact: SQL (T-SQL).

Project Acquired skills: TOAD, SQL Profiler, PgAdmin4, Light speed 5.2, Idera SQLDM 6.1,TSG ServiceNow, Rally and HPSD Tool

Trained Skills: Big Data, AWS Cloud and Greenplum

Other Tools: Lime Inventory, Lite Speed, Idera Diagnostic Manager,SIA, Asgard

CLOUD: Amazon Web Services (AWS), Microsoft Azure

PROFESSIONAL EXPERIENCE:

Confidential

Full Stack Solution Architect

Responsibilities:

• The main role of the job is to communicate with Confidential Application teams and Triage the application which needs to be migrated to cloud or Strategic Datacenter.
• Provide Application design and architecture to be on the cloud platform with defined Confidential business and security standards and obtain sign off from application team for actual migration.
• Set up/Maintain and Support Cloud Environments and Confidential strategic DC’s.
• Build EC2, Servers, Database environments in AWS cloud and in Confidential strategic Datacenter as per customer standards and initiate migration of data.
• Supporting 27000+ servers Production/Cert and Pre-Production Environments.
• Supporting 5000+ Applications in Entire Confidential Businesses.
• Worked on Migration from 2008 R2 and .
• Configured the Always on, Mirroring and log shipping and fixed the issues.
• Experience in Incident and release management team.
• In Place Upgrade Server 2008 Server 2012, Centralized Cloud, Strategic Data Center Physical
• Central Repository to collect all relevant project server information.
• Create Dataforms and complete Triage Portion of Design and Build Docs for each server to be refreshed.
• Worked on encryption and clustering technologies.
• Worked on application user requests on Cert, test and pre-production environments.
• Worked on CR deployment on Production environments.
• Creating users and groups using IAM and assigned individual policies to each group
• Maintenance and performance tuning of the EC2 and Servers to meet Non-Functional requirements of the applications.
• Responsible for managing existing operations and implementing new operations processes within organization
• Provide staff and users with assistance solving computer related problems
• Ensure technology team is following ITIL process on their daily operational deliverables and adhere to the same
• Effective use of Service Now to Assign, Monitor and track the Service Requests, New projects, Updating the tasks
• Building and Maintaining of Virtual Machines in VMware vSphere Environment
• Assess Existing Process and Recommend Service Improvements
• Timely provide operational health and status report to Internal Leadership and client management
• Prepare Flowcharts to Help Engineers Understand the operations procedures better.
• Day-to-day management of IT organization processes, including performance management, plan monitoring and evolution, metrics development
• Test, maintain, and monitor computer programs and systems, including coordinating the installation of computer programs and systems
• Implementing, and ensuring compliance with operational policies and procedures
• Identify Upstream and Downstream relationships of an application and add/remove relationship as part of the migrations and decommission of the applications and Servers.
• Perform decommission of databases, servers, web applications after the necessary data is migrated to cloud or strategic datacenter.
• Consult with management to ensure agreement on system principles.
• Accomplish information systems and organization defined service level agreement by defining the effective operational procedures.
• Service now is used for ticketing and Change management

Confidential, Atlanta

Project Lead

Responsibilities:

• Working as Cloud Database Migrations and Upgradations.
• Supporting 50+ Applications Production/Cert and Pre-Production Environments.
• Worked on Migration from SQL to RDS PostgreSQL, Oracle to RDS Oracle and SQL to RDS SQL Migrations and upgradations.
• Experience in Incident and release management team.
• Worked on application user requests on Cert, test and pre-production environments.
• Worked on CR deployment on Production environments.
• Worked functional and application support.
• Worked on RDS creations and Migrations.
• Implementing Server level, database level, Login and User level security.
• Resolving tickets with in SLA’s.

Confidential, Atlanta

Senior DBA

Responsibilities:

• Working as 24X7 Production Database support.
• Supporting 500+ servers Production/Cert and Pre-Production Environments.
• Worked on Migration from 2000 and /2014 and 2016.
• Configured the Always on, Mirroring and log shipping and fixed the issues.
• Experience in Incident and release management team.
• Worked on encryption and clustering technologies.
• Worked on application user requests on Cert, test and pre-production environments.
• Worked on CR deployment on Production environments.
• Worked on ETL and functional and application support.
• Installing and configure SQL Server 2016,2014,2012, 2008 and SQL Server 2005.
• Worked on snapshot and transitional replication.
• Implementing Server level, database level, Login and User level security.
• Using 3rd party tool SQL lite speed to take and restore the database backups.
• Checking the status of backups and troubleshooting failed backups and restoration of databases.
• Updating with latest service packs and hot fixes.
• Ensuring Data consistency in the database through DBCC commands.
• Resolving tickets with in SLA’s.
• Target Configuration into Lime Inventory for data collection
• Analyze data gaps and suggest fixes
• Weekly report from PlanET on new builds and new decommissioned to be configure in Lime inventory
• User Creation at server(Solaris, Linux and Windows) level for data collection
• OS Target Configuration for data collection into Lime Inventory
• ULA Configuration
• ALP Configuration
• Need to work with Lime Vendor to update the new feature(Patches, Up gradations)
• Analyze data gaps and suggest fixes
• Assist with activities related Lime Integration with planet
• Assist with activities related to Lime integration with OEM
• Assist with SQL Server Licenses Administration

Confidential, Atlanta

Senior DBA

Responsibilities:

• Supporting 400+ servers for MS AdCenter Production/Sandbox and Pre-Production Environment.
• Supporting mission critical 3+ TB databases
• Installing SQL 2005/2008 and 2012 in Production & Pre-Prod servers.
• Experience in Incident and release management team.
• Applying database patches in all the environments.
• Handling multiple instances failover SQL cluster for SQL 2005 on Windows 2003.
• Handling multiple instances failover SQL cluster for SQL 2008 on Windows 2008
• Planned Disaster recovery with SQL 2008 Compression feature.
• Coordinating with Dev team and fixing issues on production.
• Worked on DTS/SSIS Packages.
• Configured SQL 2005 Reports.
• Handling DB Security issues.
• Configured database backups using SQL Lite Speed.
• Setting up Log shipping & Replication.
• Rebuilding Indexes, Update statistics if required.
• Writing batch scripts on command line based using SQLCMD for executing sql files on different
• Instances & remotely stops and starts specific services.
• Automated tools for moving files between cross domains using batch scripts.

Confidential

Senior DBA

Responsibilities:

• Installation and configuration of SQL Server
• Upgrade experience of SQL Server and 2008.
• Managing Security (Creating users, logins and roles, granting permissions).
• Used DBCC utilities, updated index statistics, monitored database and disk space; involved in security issues and scheduled tasks.
• Worked on migration and maintenance of data using various utilities like Import and Export via BCP.
• Extracted data from various sources Oracle, .CSV, Excel and Text file from Client servers and through Linked servers and further populates the data to different sources.
• Created the SSIS packages to Import data from flat files, excel sheets using SQL Server 2005 and SQL Server 2008, and used SQL Jobs for scheduling and executing the packages.
• Designed and developing SSIS packages using different transformations like Conditional Split, Multicast, Union-All, Merge, Merge Join and Derived Column.
• Sending the Excel and flat file to the corresponding mail ids using Sent Mail Task.
• Created DTS packages for data migration from one table, server to another table, server.
• Exported and Imported data from text files to SQL Server using Bulk Copy Insert utility.
• Scheduled Alerts and Jobs Using SQL Server Agent
• Involved in setup and maintained Database Mirroring.
• Performed Full Backups and Transaction Log Backups. Restored them whenever necessary; created backup strategies and worked on scheduling the backups.
• Dropped and recreated the indexes on tables for performance improvements. Used Index tuning wizard for tuning of indexes.
• Loading missing data through backfill process.
• Preparing Weekly report for Disk growth and Database growth
• Implemented the audit functionality to check system resources, disc space, error messages, select, insert, delete, update activities.
• Supported 24 X 7 production environments.

Confidential

Software Programmer

Responsibilities:

• Learning new things on SQL Environment.
• Installation SQL 2000.
• Monitor the databases and maintained the Databases.
• Understanding the Stored procedures and looking the code .
• Involved in Upgrading the MS SQL Server from 7.0 to 2000.
• Creating and managing schema objects such as Tables, Views, Clusters, Indexes. Procedures,
• Triggers and maintaining referential integrity.
• Maintaining Logs and resolving performance and access issues.
• Managing Security (Creating users, logins and roles, granting permissions).