Systems Administration Resume Profile, Georgia - Hire IT People

DATABASE ADMINISTRATOR

Proficient in an assortment of technologies, including Access, MS SQL Server, XML, and Windows.

DBA skills include:

SSIS Expertise	Proficient in Microsoft Office 2013
SQL Query Development	Install/uninstall Sql on hard drive
Import/Export Wizard	Business Intelligence Environment
Data Warehouse and ETL Development	OLAP Databases

CERTIFICATIONS

Querying Microsoft SQL Server 2012, Administering Microsoft SQL Server 2012 Databases, Implementing a Data Warehouse with Microsoft SQL Server 2012, Microsoft Office Access 2013

REVELANT EXPERIENCE

Confidential

Data Administration

Experience with ETL programming and customer support, Staging and cleaning, database analysis and reporting
14 years' experience in design, development, and implementation of complex SSIS packages on Microsoft SQL Server 2012 in different types of data warehousing environments
Extracted the data from various sources like Flat files and loaded into the SQL Server database into SQL database
Designed and developed the parallel jobs for slowly changing dimensions SCD Type1, Type 2 and fact tables loading.
Derived the incremental extraction and load logic for each target table based on the source data.
Expert in load design strategies and ETL optimization techniques
Over 14 years of professional IT experience in Software Analysis, Design and Development for various applications in providing Business Intelligence Solutions in Data Warehousing.
Experience in extraction, transformation and loading of data directly from different heterogeneous source systems like flat files, Excel, SQL Server
Developed DataStage extract jobs using SQL Server Database stages and load the data into a staging area in the form of flat files/Data Sets.
Developed ETL sessions for initial full loading and incremental loading.
Extensively involved in writing Stored Procedures/Functions/Packages

Confidential

Account Executive

Managed customers' database accounts, performed customer verification and processed applications, orders and requests.
Access electronic and paper cataloging systems to look up product information and availability
Investigated and resolved service issues and/or product problems.
Successfully resolved customers internet technical problems.
Analyzed statistics and other data to determine the level of customer service performance achieved by the team

Confidential

Systems Administration

Installed new software releases, system upgrades, evaluated and installed patches and resolved software related problems. Performed system backups and recovery. Provide support for desktop running windows operating systems

Confidential

Supervisor

Designed databases to retrieve large datasets from Data Warehouse using SSIS package. Responsible for understanding the structures and data architecture in different environments. Restored and backed up databases to the server.
Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions implement best practices to maintain optimal performance.
Strong SQL development experience with MS SQL Server databases showing ability to write and execute complex SQL stored procedures in a data warehouse environment Deploying, configuring, managing, troubleshooting and optimizing SSIS services, sql server replication and database mirroring.
Proficient in T-SQL coding for Stored Procedure development.
Strong Transact-SQL T-SQL query and stored procedure development and DML
Worked with System Analysts to identify the proper sources for required data elements and to determine the accuracy of the data.
Successfully managed Extraction, Transformation and Loading ETL process by pulling large volume of data from various data sources.
Debugging / editing the existing SQL Scripts.
Optimized the performance of various SQL scripts.
Documented all process and Data Flow involved in the database for future reference.
Extensively used DataStage Sequences to place the jobs in sequence to achieve final goal.
Used complex SQL to query the database and was involved in SQL optimization of existing queries.
Successfully Installed SQL Server Management studio on laptops/desktops
Worked with materialized views to obtain optimal query performance.
Supported the database application development team to tune their applications to suit the database needs.

We provide IT Staff Augmentation Services!

Systems Administration Resume Profile

GeorgiA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship