Sql Server Data
Resume:
Kiran Jakka
Certified SQL Database Administrator
******.******@*****.*** 201-***-****
PROFESSIONAL SUMMARY:
11+ years of IT experience and extensive experience in MS-SQL Server Development and Administration including Design and implementation of Distributed/ Replicated Databases, planning/ implementing backup/ recovery strategies and Performance tuning.
Experience in Database Administration, Supporting, MS SQL Server 2000/2005/2008/2012/2014/2016/2017 Production/ Replication/Mirroring /Cluster Server Environments/Log shiping/Always-on.
Expert in data migration from MS SQL Server 2014 to 2017, 2008 to 2014, and 2000 to 2012 including Replication and clustered SQL Servers.
Experience in MS SQL Server Installation, Performance Tuning, Client Server Connectivity, Building Servers, Troubleshooting, Clustering, Query optimization, back-up/recovery, running Database Consistency Checks using DBCC and Troubleshooting on large databases, maintaining and supporting, monitoring production and test environments.
Experience in Upgrading, Service Packs and Migrating SQL Server 2005 databases to SQL Server 2008 and SQL server 2008 to SQL server 2014.
Expert in design and implementation of Always-on (AG) new feature on 2012/2014/2016/2017.
Experience in SQL Installations, Upgrade, Maintainance and Backup strategy in a SAP Application’s landscape (ECC, CRM, BI, EP and SOLMAN)
Experience on SQL Server 2005/2008/2012/2014/2016/2017 tools like SQL Server Management Studio (SSMS), SQL Server Profiler, SQL Server Agent, Execution Plan, Performance monitor, DBCC commands and troubleshooting and SQL Server Surface Area Configuration, Database Engine Tuning Advisor.
Managed day-to-day User activities like creating logins, granting permissions, applying security for new users, manually running the jobs etc.
Expert Knowledge of Integration Services (SSIS), Analysis Services (SSRS) and ProClarity.
Proficient with T-SQL, SSIS including developing and maintaining packages, developing connectivity to QlikView, SSRS, using SOAP, XML, etc., as well as having prior experience with DTS/SSIS and other ETL tools.
Creating and managing Data Warehouses Using SQL Server.
Automated the regular DBA tasks and Migration project using the POWERSHELL scripting.
Excellent troubleshooting techniques and experience with Replication, Migration and DTS
Automating the Database Maintenance tasks by creating Jobs and Alerts using the Database Mail and SQL Server Agent
Experience in data migration from existing databases to remote data centers.
Intensive experience in monitoring/tuning SQL Server and database Performance Tuning and Optimization (PTO) using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
Expertise in developing drill-through, drilldown reports using SQL Server 2008/12/14 Reporting Services (SSRS)
Experience in working with 24/7 production Environment with thorough understanding of Standard Operation Procedures (SOP) and Service Level Agreements (SLA).
Expert in using different Transformation tools like SSIS, DTS packages, BCP, DTEXEC, DTUTIL and BULKINSERT.
Involved in design and development of DTS and SSIS packages to load and process the data from Oracle, Excel, Access and flat file feeds to SQL Server and vice versa.
Expert at Dimensional Modeling and ETL design
Worked Clustering environment and configures SQL server cluster groups as a High Availability Solutions.
Experience in Installation of SSRS 2005/2008/2012/2014. Hands on generating different types of Reports using SQL Server Reporting Services (SSRS)
Experience in performance tuning of very complex SQL statements and procedures using show plan.
Expert in performing database consistency checks and planning and scheduling, Backup & Recovery.
Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional
Knowledge in Third party tools like TOAD, Auto Sys, Fog light and Lite Speed.
Self-motivated, creative team player with effective communication and Leadership qualities.
EDUCATIONAL QUALIFICATIONS:
MS Electronics and Computer Science, IASE Deemed University, INDIA
TECHNICAL SKILLS
Programming Languages: T-SQL, PL/SQL, POWERSHELL scripting, C, C++,C#.
Application Software: SQL Server 2000/2005/2008/2012/2014/2016/2017, MS Access, Oracle,SAP
DB Utilities: SQL Server Management Utilities, Query Analyzer.
GUI: DTS Import/Export, SQL Server Integration Services.
Reporting: MS Access, Excel, MS SQL Server Reporting Services 2000/2005, SSRS, and SSMS, Qlikview, SOAP.
ETL Tools: SSIS, DTS
Application Software: Microsoft Office, macros
Change Management Tool: Visual Source Safe (VSS), Team Foundation Server (TFS)
Operating Systems: Windows Server 2000/2003/2008/2012, Windows NT 4.0
Windows XP/98/95, MS DOS, Linux.
Third Party Tools: Lite Speed, Performance Dashboard, TOAD, Fog light.
PROFESSIONAL EXPERIENCE
City of Carlsbad, CA Oct 2018 - Till Date
Sr. SQL DBA
Carlsbad is a city near San Diego, in California. It's known for Tamarack Surf Beach, backed by the Carlsbad Sea Wall, and secluded South Carlsbad State Beach. The Legoland California theme park includes rides, a water park and the SEA LIFE Aquarium. The Flower Fields is a seasonal attraction, with acres of flowers. Set in a canyon, the Leo Carrillo Ranch Historic Park is home to free-roaming peacocks.
Reponsibility :
Installing SQL Server 2014/2016/2017 and administration of nearly 30+ servers ensuring zero downtime.
Manage Bulk Inserts, BCP. Script batches. Create and maintain SSIS packages (for data transformation).
Managed 30+ SQL servers including PROD, UAT, SIT and DEV.
Automated the regular DBA tasks and Migration project using the POWERSHELL scripting.
Planning the location of Data, Index, and Transaction log files on the disk.
Post deployment Installations on SQL 2017 servers on Windows 2016 servers.
Installed, configured and managed MS SQL 2016/2017 fail over Clustering for production servers on 64 bit platforms to provide high availability.
Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views.
Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema.
Extensively worked on SSIS for data manipulation and data extraction, ETL Load
Used SSIS, Import/Export to Copy, move Data from one server to another, Excel to SQL Server
Extensive knowledge in Data Modelling and deploying ETL packages using, DTS, SSIS for accessing heterogeneous data, data cleansing and auditing
Generating complex T-SQL procedures and transactions for programming purposes. Setting database connection strings, modifying ASP pages.
Thorough understanding of standard SOP’s, SLA’s and change control management process.
Extensively used Service now and share point change control management for change requests.
Generated Performance analysis reports for all the prod servers on a weekly basis using third party tool Quest Fog Light.
Intensive experience in monitoring/tuning SQL Server and database Performance Tuning and Optimization (PTO) using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
Experience with third party tools like Fog Light, Lite Speed and Veritas Netbackup.
Created Linked Servers between SQL server 2012/2014 and Oracle servers in the environment
Restored archive backups from Veritas Netbackup and refreshed the archieved databases in a desired env’s.
Modified some of the Jobs which have the steps to truncate backup log for the database which is in simple recovery mode as this option is now not supported in SQL server 2012
Created and modified stored procedures, triggers, views and indexes to provide best performance.
Conversion of the legacy systems data into MS SQL server using SSIS packages.
Designed databases for different projects and resolve database issues.
Created SSIS / DTS packages to pull data from Oracle and Flat Files.
Running DBCC consistency checks, and fixing data corruption in user databases.
Performed Database refreshes from Prod to UAT and Dev servers
Reviewed and deployed the code provided by developers in Prod and QA servers.
Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.
Experience in using Fog light monitoring application.
Environment:
SQL Server 2012/2014/2016/2017, Windows Enterprise Server 2012/2012 R2, SSIS, SSRS, SSMS, Microsoft Integration Services, T-SQL, Log shipping, Database mirroring, replication, clustering, Always-on (AG), IIS Web Server, SharePoint, SAN, Query Analyzer, SQL-Profiler, Fog light, Lite speed, IIS and Oracle.
Wells Fargo, Charlotte April 2017 - Oct 2018
Sr. SQL DBA
Wells Fargo & Company is an American international banking and financial services holding company headquartered in San Francisco, California, with "hubquarters" throughout the country.[5] It is the world's largest bank by market capitalization and the third largest bank in the U.S. by assets.[6] In July 2015, Wells Fargo became the world's largest bank by market capitalization, edging past ICBC.[6] Wells Fargo surpassed Citigroup Inc. to become the third-largest U.S. bank by assets at the end of 2015. Wells Fargo is the second largest bank in deposits, home mortgage servicing, and debit cards.
Responsibilities:
Installing SQL Server 2014/2016/2017 and administration of nearly 100+ servers ensuring zero downtime.
Principal responsibility is to implement, support, maintain, monitor & tune highly available and clustered database systems.
Involved to design and implement the Always_On (AG) on 2014, 2016 and 2017 SQL versions.
Manage Bulk Inserts, BCP. Script batches. Create and maintain SSIS packages (for data transformation).
Managed 100+ SQL servers including PROD, UAT, SIT and DEV.
Automated the regular DBA tasks and Migration project using the POWERSHELL scripting.
Worked with Terabytes of Data with over 3000 databases.
Planning the location of Data, Index, and Transaction log files on the disk.
Post deployment Installations on SQL 2014 servers on Windows 2008 servers.
Migrated Databases from SQL 2008 R2 to SQL 2014, 2014 to 2016/2017.
Manage SSRS subscriptions and security, Set cube processing
Installed, configured and managed MS SQL 2012/2014/2016/2017 fail over Clustering for production servers on 64 bit platforms to provide high availability.
Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views.
Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema.
Expert in performing multiple SSIS packages migration from SQL server 2008 R2 to SQL server 2014.
Extensively worked on SSIS for data manipulation and data extraction, ETL Load. Created extensive reports using SSRS (Tabular, Matrix).
Data conversions. DB Modeling. Create ETL processes & OLAP.
Used SSIS, Import/Export to Copy, move Data from one server to another, Excel to SQL Server
Extensive knowledge in Data Modelling and deploying ETL packages using, DTS, SSIS for accessing heterogeneous data, data cleansing and auditing
Actively involved in data warehousing of the XML onto SQL SERVER 2014.
Created Transactional Replication, Pull Subscription and defined editions to transfer data from branch to head office and vice versa.
Involved in Creation of Dimensions using STAR Schema
Generating complex T-SQL procedures and transactions for programming purposes. Setting database connection strings, modifying ASP pages.
Installed and configured 2-node Cluster Configuration (Active/Passive) in SQL Server 2012/2014
Thorough understanding of standard SOP’s, SLA’s and change control management process.
Extensively used Remedy Ticketing and CAMS (internal application) for change requests.
Generated Performance analysis reports for all the prod servers on a weekly basis using third party tool Quest Fog Light.
Intensive experience in monitoring/tuning SQL Server and database Performance Tuning and Optimization (PTO) using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
Experience with third party tools like Fog Light, Lite Speed and Veritas Netbackup.
Created Linked Servers between SQL server 2012/2014 and Oracle servers in the environment
Restored archive backups from Veritas Netbackup and refreshed the archieved databases in a desired env’s.
Modified some of the Jobs which have the steps to truncate backup log for the database which is in simple recovery mode as this option is now not supported in SQL server 2012
Created and modified stored procedures, triggers, views and indexes to provide best performance.
Conversion of the legacy systems data into MS SQL server using SSIS packages.
Designed databases for different projects and resolve database issues.
Created SSIS / DTS packages to pull data from Oracle and Flat Files.
Running DBCC consistency checks, and fixing data corruption in user databases.
Performed Database refreshes from Prod to UAT and Dev servers
Reviewed and deployed the code provided by developers in Prod and QA servers.
Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.
Experience in using Fog light monitoring application.
Environment:
SQL Server 2008r2/2012/2014/2016/2017, Windows Enterprise Server 2008/2012/2012 R2, SSIS, SSRS, SSMS, Microsoft Integration Services, T-SQL, Log shipping, Database mirroring, replication, clustering, Always-on (AG), IIS Web Server, SharePoint, SAN, Query Analyzer, SQL-Profiler, Fog light, Lite speed, IIS and Oracle.
MFX Fairfax, Ridgefield Park, NJ Dec 2016 – Mar-2017
Sr. SQL DBA
MFX is one of the largest vertical system integrator for the insurance industry, providing end to end services leveraging our strong capabilities in PaaS (Platform as a Service), IaaS (Infrastructure as a service), ADM (Application Development & Maintenance), BPO, Analytics and GRC (Governance, Risk and Compliance) services in an integrated services delivery model ( iSDM). We provide critical support and business applications to the P&C industry, processing over $2.7 billion insurance premium annually for our customers on our systems and supporting their core insurance applications, infrastructure and business processes.
Responsibilities :
Installation, configuration of MS SQL Server 2014 and 2016 for development and testing purpose.
Migration of SQL server 2008R2 to SQL server 2014 and monitoring and solving the issues after migration.
Setup, configure and monitoring Transaction Replication, snapshot Replication on remote servers.
Created and monitored database maintenance plans for checking database integrity
Principal responsibility is to implement, support, maintain, monitor & tune highly available and clustered database systems.
Involved to design and implement the Always_On (AG) on 2012, 2014 and 2016 SQL versions.
Manage Bulk Inserts, BCP. Script batches. Create and maintain SSIS packages (for data transformation).
Managed 100+ SQL servers including PROD, UAT, SIT and DEV.
Automated the regular DBA tasks and Migration project using the POWERSHELL scripting.
Thorough understanding of standard SOP’s, SLA’s and change control management process
Created Linked Servers between SQL server 2012/2014 and Oracle servers in the environment
Restored archive backups from Veritas Netbackup and refreshed the archieved databases in a desired env’s
Performed Database refreshes from Prod to UAT and Dev servers
Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.
Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking)
Environment:
SQL Server 2008/2012/2014, Windows Enterprise Server 2008/2012/2014, SSIS, SSRS, SSMS, Microsoft Integration Services, T-SQL, Log shipping, Database mirroring, replication, clustering, Always-on (AG), IIS Web Server, SharePoint, SAN, Query Analyzer, QlikView, SQL-Profiler, Fog light, Citrix application, IIS and Oracle, Sybase.
Wells Fargo, Charlotte, NC Feb 2015 – Sept 2016
Sr. SQL DBA
Wells Fargo & Company is an American international banking and financial services holding company headquartered in San Francisco, California, with "hubquarters" throughout the country.[5] It is the world's largest bank by market capitalization and the third largest bank in the U.S. by assets.[6] In July 2015, Wells Fargo became the world's largest bank by market capitalization, edging past ICBC.[6] Wells Fargo surpassed Citigroup Inc. to become the third-largest U.S. bank by assets at the end of 2015. Wells Fargo is the second largest bank in deposits, home mortgage servicing, and debit cards.
Responsibilities:
Installing SQL Server 2014 and administration of nearly 100+ servers ensuring zero downtime.
Principal responsibility is to implement, support, maintain, monitor & tune highly available and clustered database systems.
Manage Bulk Inserts, BCP. Script batches. Create and maintain SSIS packages (for data transformation).
Managed 100+ SQL servers including PROD, UAT, SIT and DEV.
Automated the regular DBA tasks and Migration project using the POWERSHELL scripting.
Worked with Terabytes of Data with over 3000 databases.
Involved to design and implement the Always_On (AG) on 2012, 2014 and 2016 SQL versions.
Planning the location of Data, Index, and Transaction log files on the disk.
Post deployment Installations on SQL 2014 servers on Windows 2008 servers.
Migrated Databases from SQL 2008 R2 to SQL 2014.
Manage SSRS subscriptions and security, Set cube processing
Installed, configured and managed MS SQL 2012 and 2014 fail over Clustering for production servers on 64 bit platforms to provide high availability.
Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views.
Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema.
Expert in performing multiple SSIS packages migration from SQL server 2008 R2 to SQL server 2014.
Extensively worked on SSIS for data manipulation and data extraction, ETL Load. Created extensive reports using SSRS (Tabular, Matrix).
Data conversions. DB Modeling. Create ETL processes & OLAP.
Used SSIS, Import/Export to Copy, move Data from one server to another, Excel to SQL Server
Extensive knowledge in Data Modelling and deploying ETL packages using, DTS, SSIS for accessing heterogeneous data, data cleansing and auditing
Actively involved in data warehousing of the XML onto SQL SERVER 2014.
Created Transactional Replication, Pull Subscription and defined editions to transfer data from branch to head office and vice versa.
Intensive experience in monitoring/tuning SQL Server and database Performance Tuning and Optimization (PTO) using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
Involved in Creation of Dimensions using STAR Schema
Generating complex T-SQL procedures and transactions for programming purposes. Setting database connection strings, modifying ASP pages.
Installed and configured 2-node Cluster Configuration (Active/Passive) in SQL Server 2012/2014
Thorough understanding of standard SOP’s, SLA’s and change control management process.
Extensively used Remedy Ticketing and CAMS (internal application) for change requests.
Generated Performance analysis reports for all the prod servers on a weekly basis using third party tool Quest Fog Light.
Experience with third party tools like Fog Light, Lite Speed and Veritas Netbackup.
Created Linked Servers between SQL server 2012/2014 and Oracle servers in the environment
Restored archive backups from Veritas Netbackup and refreshed the archieved databases in a desired env’s.
Modified some of the Jobs which have the steps to truncate backup log for the database which is in simple recovery mode as this option is now not supported in SQL server 2012
Created and modified stored procedures, triggers, views and indexes to provide best performance.
Conversion of the legacy systems data into MS SQL server using SSIS packages.
Designed databases for different projects and resolve database issues.
Created SSIS / DTS packages to pull data from Oracle and Flat Files.
Running DBCC consistency checks, and fixing data corruption in user databases.
Performed Database refreshes from Prod to UAT and Dev servers
Reviewed and deployed the code provided by developers in Prod and QA servers.
Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.
Experience in using Fog light monitoring application.
Environment:
SQL Server 2008r2/2012/2014, Windows Enterprise Server 2008/2012/2012 R2, SSIS, SSRS, SSMS, Microsoft Integration Services, T-SQL, Log shipping, Database mirroring, replication, clustering, Always-on (AG), IIS Web Server, SharePoint, SAN, Query Analyzer, SQL-Profiler, Fog light, Lite speed, IIS and Oracle.
KPMG, Montvale, NJ Jan’14- Feb 2015
Sr. SQL DBA
The system deals with the Auditing department of KPMG, making their system fully automotive. Different modules related to the auditing process are being implemented through this system, such as Business Process, Audit Objectives, Process Level Business Risk, and Risk Analysis Document etc. Reports required by the business were generated through MS Word and MS Excel. Data synchronization is maintained between all users by using Groove technology and later SQL server.
Responsibilities:
Installed, configured and managed MS SQL 2008 and 2012 fail over Clustering for production servers on 64 bit platforms to provide high availability.
Involved to design and implement the Always_On (AG) on 2012 SQL versions.
Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views.
Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema.
Expert in performing multiple SSIS packages migration from SQL server 2005 to SQL server 2008R2.
Extensively worked on SSIS for data manipulation and data extraction, ETL Load. Created extensive reports using SSRS (Tabular, Matrix).
Data conversions. DB Modeling. Create ETL processes & OLAP.
Used SSIS, Import/Export to Copy, move Data from one server to another, Excel to SQL Server
Extensive knowledge in Data Modelling and deploying ETL packages using, DTS, SSIS for accessing heterogeneous data, data cleansing and auditing
Actively involved in data warehousing of the XML onto SQL SERVER 20012.
Created Transactional Replication, Pull Subscription and defined editions to transfer data from branch to head office and vice versa.
Involved in Creation of Dimensions using STAR Schema
Installing SQL Server 2012 and administration of nearly 120+ servers ensuring zero downtime.
Principal responsibility is to implement, support, maintain, monitor & tune highly available and clustered database systems.
Manage Bulk Inserts, BCP. Script batches. Create and maintain SSIS packages (for data transformation).
Managed 120+ SQL servers including Prod, Dev and QA.
Worked with Terabytes of Data with over 3000 databases.
Planning the location of Data, Index, and Transaction log files on the disk.
Post deployment Installations on SQL 2012 servers on Windows 2008 servers.
Migrated Databases from SQL 2008 to SQL 2012.
Manage SSRS subscriptions and security, Set cube processing
Generating complex T-SQL procedures and transactions for programming purposes. Setting database connection strings, modifying ASP pages.
Installed and configured 2-node Cluster Configuration (Active/Passive) in SQL Server 2005/2008/2008R2
Thorough understanding of standard SOP’s, SLA’s and change control management process.
Extensively used Remedy Ticketing and CAMS (internal application) for change requests.
Created and modified stored procedures, triggers, views and indexes to provide best performance.
Conversion of the legacy systems data into MS SQL server using SSIS packages.
Designed databases for different projects and resolve database issues.
Created SSIS / DTS packages to pull data from Oracle and Flat Files.
Running DBCC consistency checks, and fixing data corruption in user databases.
Performed Database refreshes from Prod to UAT and Dev servers
Reviewed and deployed the code provided by developers in Prod and QA servers.
Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.
Experience in using Citrix software application.
Generated Performance analysis reports for all the prod servers on a weekly basis using third party tool Quest Fog Light.
Experience with third party tools like Fog Light and Veritas Netbackup.
Configured 43 Production servers using Foglight monitoring tool.
Created Linked Servers between SQL server 2008/2012 and Oracle servers in the environment
Created batch files for Veritas Netbackup and scheduled them with SQL Job for both system and User Databases.
Modified some of the Jobs which have the steps to truncate backup log for the database which is in simple recovery mode as this option is now not supported in SQL server 2012
Environment:
SQL Server 2008/2012, Windows Enterprise Server 2008/2012, SSIS, SSRS, SSMS, Microsoft Visio 2003, Microsoft Integration Services, T-SQL, Log shipping, Database mirroring, replication, clustering, Always-on (AG), IIS Web Server, SharePoint, SAN, Query Analyzer, QlikView, SQL-Profiler, Fog light, Citrix application, IIS and Oracle, Sybase.
Johnson controls, Milwaukee, WI July’12-Dec’13
Sr. SQL Server DBA/Developer
Description:
Johnson controls is one of the leading multinational company offering energy and operational products and services to the industries, data centers and residential clients. Company has design and development centers in the US and customers across the world.
Responsibilities:
Responsible for application configuration and migration between development, test, and production environments.
Primary responsibilities include profiling, performance tuning & redesign, high availability server network and disaster recovery.
Helping application teams in query analyzing and its optimization. Coordinating with users for downtime and maintain the system 24X7 running
Involved in designing the logical and physical architecture for database.
Created new tables wrote stored procedures for application developers and some user defined functions.
Performed data conversions from flat files into a normalized database structure.
Created and managed users, roles and groups and handled database security..
Create new SSIS Packages to extract date from Legacy to SQL Server Objects.
Installation and configuration of the reporting server.
Developed connectivity to QlikView, SSRS, using SOAP, XML.
Modified DTS to SSIS packages to accomplish critical business logic.
Develop SQL applications, procedures queries, SSIS packages, transactions to support business requirements and applications. Work with developers, support QA, and publish projects to production.
Migrated SQL server 2005 to SQL Server 2008 in Microsoft Windows Server 2003 R2 Enterprise Edition SP2.
Installed and administered two node cluster Active/passive on Microsoft Windows Server 2003 R2 Enterprise Edition SP2 on SAN environment
Migrated DTS packages from SQL Server 2005 to SSIS SQL server 2008.
Extensively worked on SQL Server Integration Services (SSIS).
Extensive knowledge in developing and deploying ETL packages using, DTS, Informatica, SSIS for accessing heterogeneous data, data cleansing and auditing
Expert in Using DMV’s, Performance dash board, Mirroring, database snapshot.
Solving the Bugs Reflected by the Testing team.
Create Reporting Data-base by MS Reporting Services.
Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server.
Designed data models using Erwin.
Data migration (import & export – BCP) from Text to SQL Server.
Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking)
Rebuilding the indexes at regular intervals for better performance.
Recovering the databases from backup in disasters
Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
Expert in implementing the snapshot isolation and DDL triggers.
Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
Implemented in new T-SQL features added in SQL Server 2008 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
SQL 2005, 2008 – Performed installation of SQL Enterprise 2008 64bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers. Patch applications.
Environment:
SQL Server 2005/2008 Enterprise, SSIS, SSRS, SSMS, IIS Web Server, SharePoint, SAN, Windows Enterprise Server 2003,IIS 6.0, Qlikview, .NET, SAN, Microsoft Visio 2003, SFTP, Microsoft Integration Services, IIS and Oracle, Sybase.
Lincoln Financial Advisory, PA, Oct’11-Jun’12
Sr. SQL server DBA
Description:
Lincoln Financial Group sells a wide variety of financial products and solutions through Financial
Contact this candidate