Sql Server Data
Resume:
Ajay Garg
SQL Server DBA
New York, NY
Phone 267-***-****
Email: ************@*******.***
Professional Summary:
Have over 14 years of experience as Sql Server DBA and total of 25 years experience in the IT industry.e/ ion
Extremely high skill in trouble shooting performance problem
Excellent team player who can work wih diverse team and give excellent results
Expert level knowledge in Sql Server Database Administration for both sql 2005/sql 2008/2012/2014 .Unattended installs, benefits of service packs,centralized Backup, Compressed backups,Security Audits,VLDB best practices,VLDB schema design,VLDB database administration and so on
Well familiar with best practices for managing sensitive data environments.
Well Familiar with building SSIS ETL for slowly changing dimensions.
Familiar with New Features of Sql 2008 like Policy Based management,Performance data collection,Data Compression,Resource Governor,Transparent data encryption,Data Auditing,Hot addd Cpu,backup compression,Extended events.
Have extensive experience implementing best practices for SSIS in production environment and for migration of SSIS from development to production.
Have experience in data modeling for both transactional and OLAP systems.
Have designed and implemented process to review code before it is migrated to production and to use win runner and load runner to load test an application before release..
Have worked with optimizing that code and giving recommendation for performance tuning the queries.
Have worked on Data Flow, Control Flow, and Error handling on SSIS.
Worked with data partitions and Loading Data Partitions to achieve High degree of parallelization and fast loads.
Well Versed with Different Data warehouse and Data Mart Building methodologies Including Ralph Kimball Enterprise data warehouse and Bill Imon’s Data Mart
Well versed with the business requirement analysis and implementation.
Knowledge of/experience in the Kimball DW/BI Design & Implementation Methodologies
Participation in consulting teams to deliver data warehouse and BI solutions utilizing the Microsoft BI platform.
Data modeling based on business requirements, and optimization of data models for business intelligence implementations
Maintenance of existing data warehouse and business intelligence implementations (involving SQL Server 2000/05/08 tools)
Migration of existing data warehouse and business intelligence from other BI platforms or earlier versions of the MS Platform
Communication with technical and business staff in technical and plain English language
Documentation of all work carried out (e.g. data models, configurations, and setup); Occasional business analysis
SQL Server 2005/08 RDBMS database Admin, Permissions SQL audit, Database audit, Folder Permissions audit
ETL implementation using SQL Server Integration Services (SSIS)
BI presentation delivery utilizing SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS) or other BI tools including ProClarity
Familiar with data partitioning at table level and switching partitionins to maintain rolling 24 months data (partition switching)
Aware of benefits in SSIS(2014) (2008) vs SSIS (2005)
Technical Skills
Databases: MS SQL Server 2008/2005/2000/7.0/6.x, ORACLE 8i, MS-Access97/2000
ETL Tools: DTS (Data transformation services), Informatics, NT Batch Scripting, Informatica, SSIS
Database Tools: OLAP, SSRS, SSIS, BI WORKBENCH, VISIO, Db Admin
GUI Tools: Visual Basic FOR application, MS Office 2000
Development skills: Transact SQL (T-SQL), PL-SQL, DDL
Language: VB Script, HTML, Source Code
Management: MS Visual Source Safe
Operating Systems: Windows NT 4.0/ 98/ME/2000, MVS, HP-UX
Hardware: IBM Compatible PC (Pentium/486/386), Compaq Pro 4500-8000 Series, Multi Processors, Array controllers.
Reporting Tools: Pro clarity, Business Objects, Crystal reports, Cognos, Informatica
Education:
Engineering from MS University Baroda
MBA from Gujarat University Ahmedabad
Certifications:
Microsoft certified SQL server DBA
Professional Experience:
City of NY, NY Jan 2016 - till date
SQL Server DBA
Performance tuning for an environment of 1100 Applications
Set up jobs to identify blocking on every server before they occurred
Identified and fixed performance issues on every server
Built Archiving with table partitioning for all tables having more than 100 million rows
Built a daily reporting structure for all failed jobs in production worked with development teams to identify fixes for SSIS packages and make sure they are implemented.
Maintained health of all servers that had performance issues monitored them using spotlight
Implemented best partitioning practices for very large databases
Monitoring of servers using spotlight
Managiing stable environment for 65000 users
Built clutesrs active active for sql 2012 instance
Identified cpu and Memory leaks and fixed them
Direct energy, Pittsburgh, PA June 2015 – Nov 2015
SQL Server DBA
Responsibilities:
Tied out an enterprise level data warehouse for all contract mart and contract usage mart for 150 billion dollar transactions.
Design review and fixing close to 1000 design and implementation defects.
Built and maintained the UAT environment for direct energy
Migration and deployment for ssis packages from source safe to sql server databases
Agile methodology implementation off shre team co ordination
Tieing out each transaction for all 150 billion dollar transaction to source to a fraction of adollar
Corporate culture change, brought about accountability for work done so that responsibility is clearly defined and carried out leading to quantum leap in productivity
Implementations of mdm
Managing diverse objectives of high level stake holders and project sponsors for a 130 million dollar project and achieving success in record time.
Deloitte (Camp Hill PA) Jan 2014 till March 2015
SQL Server DBA
Set up batch process to run data fixes every evening
Trouble shooting performance issues on uat/production server
Permission audits
Running automated jobs for synch
Troubleshooting successfully production performance issues by replication them in uat environment
Managing relationships with a community of 200 developers(making sure each of them is satisfied with he dba service responses)
Exceptional service levels for entire development community
Migration of databases from 2008 to 2012
Using tfs for source control
Automation of scripts for tfs deployments
Db comparison using red gate
Migrating schema / data between environments
Database design\Daa modeling for Arms/Child Care/ Worker web All enterprise level solutions for state of Delaware.
Working with all developer groups and modeling team to arrive at working data model and design
Identifying dependencies and addressing potential issues that could arise due to dependencies)
trouble shoot performance issues in ssis packages(commit size)(logs being filled up)
ssis deployment
Learned Desiging bar codes can work with developers to get that accomplished. Excellent knowledge of intermec printer language.
Set up applications with web server configured iis web.config to point web pages to databases.
Used debug mode in visual studio to fix performance issues in dot net code,
finding the find function being inefficient using the c sharp visual studio debugger
Helped New developers in using c sharp tools setting up web pages from tfs.
Trouble shoot performances problem in iis 8.00
Ally Bank Fort Washington(Greater Philadelphia) July 2011 till jan 2014
SQL Server DBA
Assisted with database administration for a nation-wide distributed system of more than 300 /SQL SERVER databases.
Gathered statistics and wrote UNIX /SQL CMD scripts to compress, backup and maintain the remote databases.
Developed a performance & tuning system using for Oracle, implemented role-based security, and established SQL*Net version 2.
Function performed:-
Code review,Setting up systems for identifying bottlenecks and quality of code, Setting Up Code migration processes
Trouble shooting the Production Performance issues that come up from development code migration
Setting up best practices for coders to do development of code for Large database.
Optimizing code for very large databases
Deployed active active clustered
Monitoring around 300 servers using spotlight.
Managing close to 300 servers
Built cluster servers on sql 2012
Policy based management
Maintaining 100 percent avaialibility for active active clusters.
Setting up standards and best practices so that the code is scalable and the application is scalables for very large database standards
Setting up standards so that the code is easy to configure and most configuration paramaters are table driven
Reviewing new features in latest developments that take place in the test version of sql and make sure that applications take beefit of thoise features,
Review code to make sure that non standard and future unsupported code is not incorporated during migration
Troubleshooting production performance using rml utilities
Using Trace to get code that is sub optimal in production
Identifying the bottlenecks in production using Performance monitoring counters
Setting up execution plans identifying index scans and giving recommendation for indexes setting up index creation scrips
Setting up maitainance jos for vldb
Dot net code optimization on c sharp
IIs performance issue resolution on iis 7
Trouble shooting dot net connectivity issues with database
Avanade (New York) Jan 2011 till july 2011
SQL Server DBA
Worked on a project for Reprise media /Verizon
Troubleshooting deadlock and performance issues with the production server
Code review,Setting up systems for identifying bottlenecks and quality of code, Setting Up Code migration processes
Trouble shooting the Production Performance issues that come up from development code migration
Setting up best practices for coders to do development of code for Large database.
Optimizing code for very large databases
Table partitioning and changing physical deletes to logical deletes.
Performance tuning of stored procedures
Table partitioning for more efficient deletes.
Worked on ASBS project for Verizon, Responsible for developing the solution from scratch.
Schema design etl design database design for hub and spoke architecture for the database.
Worked with hierarchal data types and xml databases in data design.
Advanced Smart Building Solutions was an initiative to capture the reduction in electric consumption by using smart building solutions for Verizon .It used Latest energy efficient processes and smart solutions to maintain temperatures within a building and shut off electricity based on occupancy.
Developed an ETL framework including detailed design for loading data from the transactional systems to the ODS and from ODS to warehouse.
Configured both table based and xml based configuration for ETL packages.
Set up package logging and error logging for ETL LOADS.
One of the largest implementation of OLAP in the north eastern region.
Worked on Building an ETL framework on SSIS and making etl packages for data loads.
Worked on Building the SSIS packages to laod data from flat files to the data warehouse using SSIS this was on sql 2008 R2
CIGNA Sept 2010 till Dec 2010
SQL Server DBA
Configured SQl server for VLDB application
Unattended installs of sql 2008
Replication Configuration for sql 20008
Bank of America /Merryl Lynch, Pennington NJ Feb 2010 till Sep 2010
SQL Server DBA
centralized sql backup process
Log shipping for warm standby
Best practices for migration of ssis packages to production
Database monitoring for lock escalation and resolution of lock escalation by using ABA lock info.
Automated the Inbound Outbound process and achieved 99% accuracy between Siebel numbers and the IO/OB data mart numbers.
Developed the ssis packages for etl design.
Developed the Validation processes and the packages for tying our and identifying wrongly entered reps
Have worked extensively in using soap to load data from disparate sources to a sql database.
Have designed Soap processes to provide a middle tier to provide content to the web sites.asp
Working on maintaining asp ts sites
Worked on maintaining java scripts in prod envirnments
Retail Solutions INC, Providence, RI Dec 2009 till feb 2010
Sql server DBA
Unattended installs for sql 2008 bot for sql server 2008 and for analysis services 2008
Configured Physical and logical layout for VLDB Databases for retail sciences.
Configured Analysis server and optimized it for vldb
Set up automated maintenance jobs for sql server.(backup database consistency checks)
Partition Loading for sql server 2008
Included activity monitor to monitor performance of the boxes
Implemented sql 2008 audit on sql 2008 box
Implemneted compressed backup for sql 2008
Metavante Corporation / FIS, Chester brook PA Jan 08 – Dec 09
SQL Server DBA
Maintained the databases and the sql server which was been offered as a hosted service for the clients of the hosted banking application.
Migration of SSIS packages from dev to production using the deployment wizard and manifest file.
Configured warm standby server using log shipping
Configured the server for mirroring of databases on the hosted server.
Performed Query Optimization and Improvement using query optimization plans.
Horizontal And Vertical partitioning of data for VLDB Databases
Creation of Physical Database design based on the VLDB best practices.
Batch Inserts when using SSIS or stored procedures for VLDB table inserts based on insert date.
Daily refresh of cubes and Creation of Cube Refresh Task on SSIS.
Solved database related problems(locking) for suntrust bank and identified the queries that were causing problems at the bank
Solved the performance issues with the sun trust environment
Set up the process for query review of database performance for the sun trust release
Centralized backup server for hosted services
Data clean up and log truncation on a weekly basis.
Reverse engineer existing packages and create detailed design documents to fix issues in the existing loads.
Worked extensively in parsing xml for data loads
Worked extensively in loading data from different sites to a central data warehouse
Created a content management system to be the centralized repository to feed several web sites.
Used xml extensively to load information from the content mgmt system to the separate content stores and repository.
Used xml spy extensively,
Used web services for soa data loads
The Philadelphia Mayors office, Philadelphia, PA Jan 2007 till Jan 2008
Sql Server DBA/Database Developer
Maintenance jobs and email alerts for the production server
Centralized backup for the server
Created logical and physical design of the database
Creation of the log shipping for the backup server
set up centralized backup process for all the server which took them onto veritas tapes and then off site
Security audit of sql server and the Audit of the folders and the plans.
Created the detailed design document for the mart, Created the Detailed design document for the Upload process from Lock and Track to AXIOM this was for metadata driven staging loads
The staging load process was metadata driven and could be configured for different data sources (flat file, xml. Odbc, Ole db )
Largest Data warehouse implementations on SQL Server
Database design ETL design and Schema design
Used SSIS in SQL 2005.
Creation of data model using Erwin.
Data Conversion from Oracle RDS to flat files and to SQL Server 2005.The database Size is 350 GB. We were using SSIS to load the data.
Created reports from Database Using SSRS
Created detailed design document for Physical and Logical design for the data warehouse load implementation.
Created Network design Architecture design documents for the higher level designs.
Creation Of data mart for the axiom project, Creation of ETL and detailed design document for the Axiom Project.
Data validation systems and Data Cleansing systems for Population the ODS with scrubbed and enriched data.
Well familiar with star and snowflake Schemas and implemented them in the solution..
Performed Query Optimization and Improvement using query optimization plans.
Used Version and source control to maintain the different versions for each build.
Environment is SQL 2005
Designed the Architect model, developed Validation systems for the star schema on the SQL Server Environment.
Populated 4 schemas, Incarceration, Incarceration Time, Incarceration event, Judicial using SSIS packages.
Designed and implemented data cubes using to facilitate executive, management and end user reporting.s
First Trust Bank, Philadelphia, PA 01/2006 – 01/2007
SQL Server DBA/Database Developer
I was Responsible for Development and production environments of on SQL server and OLAP and SSRS.
I was Responsible for SQL development to production migration on SQL Server Reporting Services 2005.
Created logical and physical design documents.
Centralized backup server
Centralized system for taking backup files on tape
Centralized system for security audit on sl server
Use of certificates to validate database access
Log shipping configuration for warm fail over
Wam Systems Software Company, Philadelphia, PA 3/05 - 12/05
SQL Server DBA/Database Developer
Developed the backup strategy for cubes for the application.
SQL server SSRS ssis migration plan from development to production.
Data warehouse data validation and design automation of jobs and monitoring.
SQL SERVER DBA/DATABASE DEVELOPER performance optimization.
DBA duties making sure service packs are Applied, documenting servers /database and service packs used.
Environment: SQL SERVER, Windows XP, T-SQL, DTS, SQL Profiler, SQL SERVER Agent
Health Professional Insurance Services Division, Philadelphia, PA 1/05- 3/05
SQL Server DBA/Database Developer
Worked with VLDB (very large databases) to optimize schema and create the ANALYSIS SERVICES schema for a VLDB application.
Centralizd backup system.
Database tuning and setup for vldbs
Physical and logical design of databases.
Cluster Configuration Active cluster.
Responsible for Security Planning and disaster recovery for the server and the Data Warehouse.(defined a disaster Recovery strategy for the data mart/Data warehouse and ANALYSIS SERVER databases)
Environment: SQL SERVER 2000, DTS, SQL SERVER Analysis Services, Windows XP, NT, SQL Server Agent,
IBC (Independence Blue Cross), Philadelphia, PA 01/2004 - 01/2005
SQL SERVER Architect.
Defined best practices for SSIS and ANALYSIS SERVICES cubes.
Worked on defined standards for Secured Software development process.
Created Use case and Misuse case scenarios for a secured development process standpoint.
Created ETL Jobs using NT batch scripting and NT Batch files.
Created database data mart mappings
Created system design, data base design and detailed design documents.
Created the staging, Data warehouse databases and the ANALYSIS SERVICES repository for the analysis server.
Defined naming standards and the ETL standards for the jobs.
Created the business requirements and the detailed design document for the Hedis simple measures cube.
Created 3 cubes for a) Hedis simple measures (Loaded about 100 Million rows Table size 4 Gigs) b) Emergency room utilization cube c) Medical cost Calculation cube. Wrote the ETL jobs created tables and stored procedures for data transformation and validation and also created the cube structures.
Created the jobs to populate the cubes and set up alerts to indicate job failure.
Set up jobs to truncate the log files in case of extensive growth during inserts.
Defined best practices for ETL jobs, Defined best practices for ANALYSIS SERVICES Development, defined best practices for SQL development and naming conventions.
Wrote the documentation for the ARB meeting and created prototype for the Member Months by product line cube, The ER Visit Cube and the Medical Cost Cube. These took data from the Membership, Claims Database.
Responsible for configuring Cognos as a front end for Analysis Services cubes.
Created processes which loaded about a 100 million rows in fact tables, created Shared dimensions which could be shared across multiple cubes .Also created jobs which would populate the Dimension and the fact tables Automatically and in case of failure would trigger another job. Created packages which would create off line cubes form existing cubes.
Environment: SQL SERVER, SQL SERVER Analysis Services, ETL, DTS, T-SQL, Erwin, Stored Procedures, Cognos, Impromptu, TOAD
Stanley Tools, Philadelphia, PA 11/2003 - 01/2004
ETL Architect
Created Dts packages to load large cubes and create incremental laod jobs.
Automation of error reporting and building of validation systems.
sp Optimization and code review
AAAE (American Association of Airport Executives), Washington, DC
ETL Architect
AAAE: AAAE is the Association for all airports of US and IAEE is the association of all Airports of the world. The AMIS application takes care of the reporting needs of AAAE. AMIS takes data from transactional systems and reports on membership data across different dimensions like Airports, regions, Managers, time and also membership type.
Developed the DTS jobs which took data from the different systems like the Solomon transactional system, the billing system and the membership system and created the staging dimension and fact tables.
Besides the development responsibilities I also handled the responsibilities for providing production support to the AMIS application, maintaining security for the AMIS production server and also configuring and maintaining database maintenance plans.
Re-indexing databases and running DBCC checks.
Defined and developed a database backup and restore plan, a disaster recovery plan. Implemented multiple instances of SQL server on SQL 2000.
Environment: Windows 2000 Advanced Server, Windows 2000 Server, SQL server 2000/Analysis services, SQL server 7.0 /ANALYSIS SERVICES, Crystal Reports, Cold Fusion, ERWIN.
Primavera, PA 09/2001 - 11/2002
ETL Architect
Primavera is the market leader in Project Management Software. Responsible for all development and Database management activities of the Data warehouse.
Responsibilities:
Worked on an Application called PRIMS. Prims were the front end for an enterprise data warehouse which had 4 data marts and 23 different cubes.
It was an excel application which sat atop ANALYSIS SERVICES cubes used VBA to access the cubes and display the Facts and dimensions on an excel spread sheet.
Subsequently evaluated Pro clarity and business objects as a front end for the ANALYSIS SERVICES implementation.
Designed and implemented an enterprise data warehouse which took data from 3 transactional sources: CRM system called ONYX, financial system called Solomon, and a home grown invoicing system.
Created the Data warehouse databases and the staging databases and the ANALYSIS SERVICES repository
Register them, then would open a work sheet which would display the facts and dimensions for a cube.
Implemented the cube structures and stored them in the ANALYSIS SERVICES repository
Designed the DTS jobs which took data from transactional system to the staging database and from the staging data base to the data warehouse
Defined 5 data marts and designed and implemented 23 different cubes in all
Designed the STAR schema for the cubes
Designed the front end initially as Excel for the data warehouse which would connect to the ANALYSIS SERVICES repository
Designed the security for the ANALYSIS SERVICES environment in terms of user roles
Designed and implemented the data validation routines for validating user errors from the source system to the staging areas
Front end tool evaluation
Off line cube for off shore offices to enable reporting in case of connectivity problems
Backup and disaster recovery plan for cubes in case of failure
Defines the design methodology for implementing an ODS for the data warehouse.
Data integration from multiple sources defining and developing mixed dimensions.
Took training on Pro clarity for implementing as a front end for the cubes.
Data Warehouse Responsibilities
Responsibilities included 24x7 support of the warehouse initiative.
Job Monitoring and making sure all jobs ran successfully every night
Data Validation, feed back to users and implementing changes in validation processes based on user feedback
Planning new initiatives on the ANALYSIS SERVICES implementation including interacting with Microsoft for removing limitations of analysis services for large implementation.
Ad hoc querying of cubes using MDX and MDX implementation in calculated measures of cubes.
Developing MIS concepts and alerts based on ad hoc queries and Management Requirements.
Environment: Windows 2000 Advanced Server, Windows 2000 Server, SQL server 2000/SQL 2000 Analysis Server, Pro Clarity, DTS
Contact this candidate