Data Sql

Geethanjali Krishnappa

Philadelphia, PA +1-267-***-**** ************@*****.*** Linkedin

Professional Summary

●Over 4 years of experience in Database Administration, System Analysis, Design, Development and Support of MS SQL Server 2014/ 2012/ 2008 R2/ 2008/ 2005 in Production, Test, Development, Replication and Cluster Server Environments.

●Expertise in Database Administration on Production Servers with Server Conjuration, Performance Tuning and maintenance with outstanding troubleshooting capabilities. Experienced in Upgrade/Migration of MS SQL Server 2008 to MS SQL Server 2008R2, from SQL Server 2012 and SQL Server 2014.

●Experience working with application teams and implemented databases as per the speciation from LOB applications. Experienced in installation, conjuration, maintenance and optimization of SQL Server HADR solutions.

●Experienced with partially contained databases. Experienced in Backup and Recovery, Query Optimization and Security.

●Experienced in monitoring the health and performance of SQL servers as well as home grown applications using SQL Server native tools and several other third-party solutions.

●Adept at T-SQL, stored procedures, tables, indexes, views, functions, and triggers.

●Expert in creating DTS packages to utilize SSIS functionalities and DB dependency resolutions. Created various SSIS, SSRS and SSAS Packages to serve company needs. Familiar with PCI Compliance Standards required for Retail Industry.

●Experienced in working independently as well as in team-oriented environments.

●Expert in problem solving, analysis and convict resolutions. Experienced in supporting and maintaining large databases and troubleshooting their problems.

●Excellent analytical, communication and interpersonal skills.

Education

Master of science in data science

Drexel University, Philadelphia, PA, United States

·HONORS: Dean’s Fellowship.

Bachelor of computer application

Jain, University, Bangalore, India.

Skill set

RDBMS and tools

MS SQL server 2012, 2008, MS SQL Server 2005, Oracle 9/10/11/12g, Postgresql

Programming language

Python, C++, Basic Java, T-SQL, PL/SQL

ETL tools

DTS, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS) 2012/2015, Microsoft Visual Studio 2015 /2016,

SQL server tools

SQL server management studio (SSMS), Power BI, Tableau

Data warehousing and BI

Star schema and snowflake schema

Operating systems

Windows 7,8,10

Other tools

Microsoft suites (word, excel, PowerPoint), MS SharePoint

Professional experience:

Vanguard, Malvern, PA May 2020 – Present

Role: SQL Server DBA

Responsibilities:

·Configured, Installed, and Maintained SQL Server 2000 & 2005 in development, test, and production environment

·Installed and Configured Operating Systems, Windows Server (2000 & 2003)

·Installed and Configured SQL Server Reporting Services (SSRS)

·Configured and Maintained Replications, Log Shipping

·Upgraded databases from SQL Server 7.0/2000 to 2005 in testing and production environment

·Upgraded MS Access 2000/97 databases into MS SQL Server 2000, and 2005

·Applied SP (Service Pack) and patches on SQL Server 2000, 2005, Windows Server 2003 Enterprise Edition

·Expertise in database Performance tuning

·Writing T-SQL and Stored-Procedures

·Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers

·Data Modeling, developing E-R Diagram using ERWin and SQL Server Data Diagram

·Backward & Forward Engineering with data modeling tools mentioned above

·Export & Import data from Flat file, CSV file, Oracle, and Access to/from SQL Server Database using DTS, SSIS, and BCP

·Generated Report using SSRS and in Excel, html, text from Database as well

·Working experience in Database Backup, Restore and Point-in-Time Recovery

·Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification

·Developed Different Maintenance Plans for database monitoring

·Monitor Server Activity, Error Log, space usage, and solving problem as needed

Environment: SQL Server 2008/2005/2000, Windows 2003 Server, T-SQL, MS Access, and DTS, SSIS, SSRS, SSAS, MS SQL.

Fastlane Technologies, Bangalore, India July 2017 – Feb’ 2019

Role: SQL Server DBA

Responsibilities:

·Demonstrated experience creating and maintaining SSIS packages for Data Warehousing

·Independent worker capable of evaluating and resolving database issues

·Experience as a DBA in a fast paced, high growth, technology and intensive environment

·Experience with Microsoft SQL and in a clustered, adhoc SQL queries, log shipping and store procedures

·Solid background of SQL Server native/SharePoint integrated reporting services administration, reporting services security, configuration and report deployment

·Solid background in Windows server administration, Analysis Services, Integration Services, or Reporting Services

·Serve as support for database administration tasks including configuration management, backup/recovery, performance optimization, and space management

·Perform database deployments and provide support for application releases

·Assist developers with MS SQL Server issues and questions

·Interface with developers, network, virtualization, storage and systems operations teams to resolve problems with applications and database systems

·Design, develop, test, deploy and maintain database security and audit solutions

·Administer and monitor 24/7 applications and systems, developing automated alerts to warn of failure

·Plan and Lead database development, documentation and maintenance of databases including

Environment: SQL Server 2008/2012 Enterprise, Windows Enterprise Server 2012, Microsoft Visio, Microsoft Reporting Services.

Icon Technosoft, Bangalore, India Aug’ 2015 – Jul’ 2017

Role: SQL Server DBA

Responsibilities:

·Create User Defined Functions, Stored Procedures, and Triggers

·Performed data conversions from Flat files into a normalized database structure.

·Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis

·Created triggers, views, user defined functions to incorporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective

·Experience in developing the Cubes using SQL server analysis services (SSAS), with star schema and snow flake schemas

·Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard

·Experience in collecting the user requirements and documenting by creating the use case and flow activity diagrams

·Responsible for creating constraints, Indexes, and Views

·Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary

·Used Database Maintenance Wizard to make necessary changes and to keep the performance of the server at acceptable levels

·Configured Server for sending automatic mails to when a DTS process fails or succeeds

·Transformed data from various data sources using DTS packages

·Experience in creating the OLAP multidimensional cubes

·Responsible for MS SQL Server 2000 in Production, Test, Development and Replication & Cluster Server Environments.

Environment: SQL Server 2000, Windows 2000 Advanced Server, Windows 2003 Server, T-SQL, MS Excel, MS Access, and DTS, SSIS, SSRS, SSAS, MS SQL.

Contact this candidate