SUMMARY:

• 8+ years of experience on the design, construction and implementation of Business Intelligence tools, ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Validation, MSSQL Databases.
• Able to work with multiple teams. Familiar with monitoring tools (Idera, Red - Gate, SQL Sentry) Standard DBA functions/skills • Installation of SQL Server and its components • Security - knowledge of SQL server security best practices • Stored Procedures • SQL Agent •
• Proficient in using T-SQL, writing Stored Procedures, Triggers, Functions, and Cursors in SQL Server . Good experience using various transforms in SSIS as an ETL tool while transferring the data from various sources into the destination files.
• Extensive experience in creating complex SSIS packages for ETL purposes using various transformations in SSIS 2005, SSIS 2008R2, and SSIS 2012. Transformed data from various data sources to SQLServer using DTS, SSIS 2005, SSIS 2008 R2 and SSIS 2012. Clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Proven ability in defining query for generating drill down reports, matrix reports, chart reports and handling parameterized reports, creating on demand and scheduled reports in SSRS 2005, SSRS 2008.
• Experience in performance tuning and optimization of queries and stored procedures. Experience in all phases of project life cycle, starting from business requirement gathering and analysis to testing and deployment. Proficient in using SQL Profiler, Execution Plan and Performance Monitor.
• Skilled in performing Backups and Recovery, Replication, Security management, Jobs and working with Linked Servers, Mastered creating the OLAP cubes using various dimensions and creating SSAS projects using SSAS 2008R2.
• Adept in defining referenced relationships and calculated members in SSAS and used MDX queries, creating OLAP structures from OLTP databases.
• Experience in designing, maintaining & tuning various RDBMS like T-SQL & SQL Server .
• Hands-on experience with Erwin and strong knowledge of relational database modeling and dimensional database modeling concepts, fact tables, dimensions and star/snowflake schemas implementation.
• Knowledge in creating web applications using ASP.Net, XML, HTML, Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Involved in DBA activities such as backups, restores, replication, excellent communication skills, analytical skills, understand business requirements in various domains.

TECHNICAL SKILLS:

Operating Systems: Windows 98/2000/2003/ XP/NT/Vista/7, Windows Server 2003/2003 R2/2008/2008 R2

Database Tools: SQL Server Management Studio(SSMS), SQL Profiler, Query Analyzer, DTS Designer, Index Tuning Wizard

GUI Tools: SQL Server Business Intelligence Development Studio, ER Studio, Visual Studio 2005/2008/2010

Languages: T-SQL

OLAP Tools: SSAS, SSRS

Source Control Tools: Visual Source Safe 2005, Team Foundation Server 2010

ETL Tools: SSIS, DTS, Import/Export Wizard

PROFESSIONAL EXPERIENCE:

Confidential

S QL SERVER DBA

Responsibilities:

• Responsible for ensuring a stable production environment using change management systems.
• Participated in the data warehousing of major deployment and Migration projects.
• Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
• Helped developers tune queries, assigned proper indexes, and aided developers in the creation of triggers and stored procedures.
• Monitored log space of all the instances with generation of reports.
• Showed the developers and junior DBAs how to use and take advantage of the SQL Server Index Tuning Wizard and the SQL Server Profiler.
• Experience managing multi-terabyte production of both STANDBY and CLUSTERED systems using ACTIVE-PASSIVE Clustering.
• Applied Service Packs to SQL Server 2005 and 2008R2 for updates and security.
• Established naming conventions and standards for the SQL Server and databases and made sure that everyone stuck to them.
• Established standards and schedules for database backups by making sure that the backup schedules meet the recovery requirements on a daily, weekly, and monthly basis. Used the RESTORE VERIFY option when creating backups.
• Created Integration Services (SSIS) to perform multiple data extractions from different applications.
• Performed Administration tasks (Replication, Tuning, Configuration, and troubleshooting SQL Server 2005/2008/2012 .
• Configuring Indexes for Maximum Performance-Configuring Index statistics, Exploring Fragmentation Considerations, Implementing fill factor administration, determining when to rebuild or reorganize an index, sorting indexes in the TempDb, using the database engine tuning advisor.
• Analyzed all informational requirements of new or production systems and develops database specifications.
• Responsible for installing SQL Server and upgrading an existing SQL Server and ensuring the success of the upgrade.
• SQL server profiler-used as an auditing tool for security proposes to capture traces, restricting the events and diagnosing problem queries.
• Responsible for importing and exporting data to and from the SQL Server using BCP and SSIS
• Worked as a team member with other DBA's to ensure 24 x 7 production support of all corporate databases.
• Performed backups of all SQL servers 2005/2008/2012 daily, weekly, and monthly.
• Ensured security of the database servers by implementing applicable security patches and maintaining appropriate security measures.
• Migrated database object using SSMA (SQL Server Migration Assistant)
• Experience in creating, monitoring and backup, recovering and tuning SQL Server databases in a multi- platform environment.
• Monitored and maintained database performance and identified/recommended areas that can be improved.
• Managed and executed maintenance jobs that ensured the stability and performance of the database servers.

Confidential

SQL Server DBA

Responsibilities:

• Providing 24/7 support for critical production databases.
• Providing Primary DBA responsibilities for around 10 applications.
• Migrated the SQL Server 2000/2005 to SQL Server 2008 and 2008 R2 versions.
• Managed 200 databases and few huge databases which are more than 5TB.
• Installed of MS SQL 2012 on production, Test and Development boxes.
• Working on Projects to provide DBA support for building SQL Servers for new applications begin to end support
• Monitoring the data files, log file space issues, blockings, Tempdb space issues.
• Planning for backup and recovery of database information and maintaining Hot Backups, Cold Backups.
• Working with BMC Patrol Monitoring tool and lite speed Backup tool.
• Administering the MS SQL Server 2012, 2008, 2005 2000 by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Involved in General Database Administration, Query Performance tuning.
• Manage SSIS packages, stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks other locking issues. Performed Database consistency checks with DBCC Utilities like DBCC DBREINDEX, DBCC INDEXDEFRAG, Index tuning and monitored error logs.
• Developed few reports using MS SQL Reporting Services.
• Refreshes from Production backup to Stage and Development environments.
• Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting. Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
• Extracted data from various sources like SQL Server 2005/2008/2012, Oracle, Teradata, .CSV, Excel and Text file from Client servers and through FTP.

Confidential

SQL BI Developer/DBA

Responsibilities:

• Working with Change Request Any changes in Production database need to Create CR Tickets this should be approved by Global DBA team after changes made in stage and development environment
• Involved in all ITIL process like Change management, Incident Management Problem Management.
• Environment: Windows 2008/2003/2000/ NT4.0, MSSQLServer2012/2008R 2/2008/2005/2000, SSIS, SSAS, SSRS, System Monitor / Performance Monitor, Fog light and BCM PATROL Lite Speed.
• Deployed SQL Server 2012 by upgrading existing instances of SQL Server 2008 R2 using installation wizard.
• Migrated SSIS packages from SQL Server 2008 R2 to 2012.
• Assisted with the migration of MS SQL Server 2005 back-end single Server environment (Development/Production) to a new MS SQL SERVER 2008 back-end multi- Server failover environment (Development vs. Production).
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Designed and developed packages using Integration services (SSIS) SQL Server 2005/2008R2.
• Extracted data from databases like Oracle, Teradata, Sybase and MySQL and migrated into SQL Server using SSIS.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Involved in installation and configuration of SQL Server 2008.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Wrote VB.NET code in script components in SSIS to validate the Data from Data base sources.
• Created the SSIS /DTS packages and scheduled them.
• Developed ETL packages with different data sources (SQL Server), Flat Files, Excel source files, XML files etc.) And loaded the data into target tables by performing different kinds of transformations.
• Imported data from text files and excel spread sheets into SQL Server 2005 database using SSIS package.
• Worked with Pragmatic works DTS xChange tool to convert DTS packages to SSIS 2005.
• Experienced in Replication as a Disaster Recovery Solution and Load balancing.
• Immediately following the server cut-over, perform additional database performance tuning and database support.
• Monitoring success and failure of automated jobs, monitoring system availability, updating system documentation, system and database recovery, etc.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• 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. 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. Environment: SQL Server 2005/2008R2/2012 Enterprise Edition, SSIS, T-SQL, Windows Server 2008, VB.Net, Microsoft Business Intelligence Studio, DTS xChange, SQL Profiler, Database Engine Tuning Advisor.

Confidential

SQL Developer/ DBA

Responsibilities:

• Gathered business requirements, definition and design of data source and data flows.
• Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS
• Created new SSIS packages and Modified existing packages as per the requirement during the deployment.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Logging to invoke packages created Stored Procedures, views, triggers.
• Designed packages using Transformations such as Execute SQL Task, Sequence Container, For Each Loop Container, Lookup, OLE DB Command and Derived Column. In SSIS worked on a workflow which links together modular data-flows as a series of operations In order to achieve a desired result.
• Migrated data from various data sources using SSIS Transformations like Aggregate, Lookup, Conditional-split, Merge Join and Sort. Helped design and implemented processes for deploying, upgrading, managing, archiving and extracting data for reporting. Responsible for updating staging and dimensional databases as well as rebuilding the dimensions and cubes on Analysis Services
• Training technicians on new HP platforms assisting and supporting in doing extensive research to improve the quality of products, creating solutions to complex technical problems and increasing customer satisfaction.
• Provided help and support for repair technicians. Run the aging and must ship unit report (excel) making sure we ship the units to the customer as soon as possible.
• Conducted regular production meetings to discuss any issues and find new solution on how to improve production. Monitored the production line to ensure all the employees met their KPI (key performance indicators) in order to meet company goals.
• Other duties as assigned including tracking and correcting employee time sheets in the Paycom system when needed, and managing the Quality Control Department.
• Responsible to develop and maintain the databases of the organization, Build up the database architecture and models and Design the schemes, permissions and tables for database as appropriate for its use
• Install, configure and upgrade the server to suit the database needs, Design automated systems to mine information and make reports
• Provide inputs for developing newer versions of databases customized to peculiar needs
• Include objects in database like tables, views, functions, triggers, etc.
• Control the access for database by giving security password and permissions
• Researched markets for advancements and advocated the use of new database technologies
• Provided constant online or on-call assistance to end users for handling their queries
• Maintained a backup or recovery options to retrieve the lost data, Performed data cleansing and data migration functions
• Assisted in building strategies for installing and improving the database
• Inspected the operations of the database as per the standards set by the organization
• Thorough knowledge of the, MS Image Composer, Enterprise Manager, etc. and computer programming languages like XML, SQL (SSIS/SSRS/SSAS), Linux, etc.
• Efficient networking skills in MS SQL Server, LAN installations, wireless networks, also technician support diagnose and working on the software and hardware in server work station and laptops repair
• Build and rebuild databases from backup.
• Designed and developed database schema to support corporate wide data business models and applications. Developed overall security management process for all production servers
• Responsible for database migration (version upgrade), development and review
• Install SQL Server 2012. . Familiar with monitoring tools (Idera, Red-Gate, SQL Sentry) Standard DBA functions/skills