SUMMARY

• 6+ years in - depth experience in managing multiple MS SQL Server 2000/2005/2008/ R2/2012/ servers Oracle Database and production environments while ensuring their performance, high availability and internal/external security.
• Logical and physical planning of relational databases; managed internal databases from planning and testing stages through implementation and support.
• Hands on experience in Installation, Configuration and Migration of SQL Server 2012/2008/Oracle Database, apply periodic service packs and hot fixes (cumulative updates) and complimentary third party tools.
• Expertise in creating database objects and structures including databases, tables, indexes, views, snapshots, stored procedures, triggers, functions and cursors.
• Experience in developing complex TSQL scripts and stored procedures to perform administrative tasks and multiple DDL, DML, and DCL activities to carry out business requirements.
• Extensive experience in performance tuning / analysis, troubleshooting and query optimization using native tools like MSSQL server profiler, activity monitor, performance monitor, event viewer, index tuning advisor, database tuning advisor (DTA), Dynamic Management views (DMV), services and protocols, and configuration manager.
• Experience in using dynamic management views (DMV) and dynamic management functions (DMF), TSQL scripts, Triggers, and Store Procedure for troubleshooting and performance tuning that include finding out long running queries and query costs.
• In-depth understanding of user management and database security at different levels to ensure database integrity and secure databases from unauthorized intrusions and data corruption.
• Extensive experience in designing, implementing and maintaining high availability and disaster recovery plans including: back-up and restore, log shipping, replication (transactional/merge), database mirroring, failover clustering and always-on
• Expertise in automating maintenance jobs in SQL server job agent and task scheduler: such as Shrinking database, index rebuilding, creating filtered indexes, index reorganizing, cleaning up, updating statistics and full, differential and transactional log backups and other SSIS package tasks.
• Extensive experience in using Version control system tools for deploying scripts and packages.
• Experience in Extract, Transform and Load (ETL) data from heterogeneous data Sources like Oracle, MS Access, and MS SQL using MS SQL Integration Service (SSIS), DTS, BCP and Bulk insert.
• Experienced in creating, managing and delivering server-based reports with interactive views that provide valuable insight for business heading using MS SQL Reporting service (SSRS).
• Experience with AWS/Azure Cloud Technology server Analysis Services (SSAS).

TECHNICAL SKILLS

Relational DBMS: Microsoft SQL Server 7.0/ 2000/2005/2008/ 2008R2/2012, Sybase, Microsoft Access.

Server operating systems: Windows Server 2003/ 2008/2012/2014 /2016 and 2017R2. /Linux/Active Directory

Database Programming: T-SQL, PL/SQL.

Programming: C++, HTML, JDBC, XML, VB.NET, ASAP.NET.

Database modeling: VISIO 2003/2010, Toad Data

ETL tools: MS SQL Server integration services /SSIS/, DTS.

Reporting: SAP BO, SQL Reporting Service /SSRS/Tableau/Crystal

Third party tools: Symantec, Red Gate., Toad

Applications: IIS, Visual Studio, FTP, Adobe Photoshop suite, Dreamweaver, Web Logic, SharePoint.

Networking: SAN, NAS, LAN, WAN, CHECK POINT SECURITY and CISCO ASA

PROFESSIONAL EXPERIENCE

Confidential

Information Database Security Analysis

Responsibilities:

• Contributes to team effort by accomplishing related results as needed.
• Determines changes in physical database by studying project requirements, identifying database characteristics, such as location, amount of space, and access method.
• Protects database by developing access system, specifying user level of access.
• Maintains user reference by writing and rewriting database descriptions.
• Username provisioning on different on databases Oracle, SQL server, Teradata
• Developing different script for UAT and production server
• Strong Experience in Performance Tuning including Updating Statistics, Re-Indexing Query Optimization, Client/Server Connectivity and structure modification.
• Extensively used the native tools like Index tuning wizard, Database tuning advisor, SQL profiler, Performance monitor, Activity monitor, Event viewer for performance analysis.
• Complete analysis on aging tickets and working with those groups that are lagging in Users contact, ticket updates and close outs
• Responsible for Oracle DB and SQL server logical and physical database design, implementation, and maintenance.
• Install, configure oracles and Server 2005/2008/2008 R 2/2012/2014/2016/2017
• Strong initiative; self-starter; self-directed; ability to multitasks.

Confidential

SQL Server BI Developer (SSIS/SSAS/SSRS)

Responsibilities:

• Developed Logical and Physical models based on the business requirements. Created ER Diagrams using Visio.
• Created MOLAP Cubes and automated the Processing options on different servers. Optimizes the processing time by tuning the DSV queries and created SSIS Packages eliminating complex syntax in Data Source View.
• Created the Partitions, Aggregations and various custom Member calculations in the Cube. And also developed drill through actions which would navigate to SSRS reports deployed to Report manager.
• Used MDX studio to debug complex MDX queries and improved the Performance of MDX Calculations.
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS.
• Built various filters using the Named Sets, MDX Query, Member Selection and Custom Tables.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities. Created and scheduling maintenance jobs in new environment using SQL Server Mailing Agent in SQL Server.
• Worked with the Program Architect and Technical Architect in design sessions to develop high-level solutions architecture for SQL Server Reporting Services solution.
• Developed, implemented procedures to ensure the quality, use and accuracy of reports.
• Ensured crucial project deadlines/milestones are met without compromise on Quality of the Product.

Confidential

SQL Server BI Developer (SSIS/SSAS/SSRS)

Responsibilities:

• Creating/Modifying existing SSIS Packages in 2008, 2012 and 2014.
• Upgrading SSIS Packages from 2008 to 2012. Converting the Package deployment model to Project deployment model. Configuring the Integration services catalog Projects/Folders and Environments for the deployment and execution. Converted all package level xml/sql server configurations to Project/Package level parameters.
• Created stored procedures to execute package from another project after migrating to Package deployment model.
• Developed SSIS packages to Process the Cube, Backup and Restore on the Production server. Scheduled the cube refresh to get the latest information updated.
• Designed high level ETL Architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Developed SSAS Tabular Cubes on 2016 and made use of the new calculated tables in 2016 using DAX expression.
• Created new SSAS Tabular models and modified existing to satisfy new business requirements. Used DAX (Data Analysis Expressions) to create SSRS reports on top of the Model.
• Created different security roles and implemented column security to show/hide sensitive data.
• Defined Attribute relationship, created hierarchies, and for ease of use, grouped the attributes to folder structure within the dimension structure as “attributes” and “hierarchies”.
• Identify, recommend, and implement new database administration technologies.
• Worked with a team of ETL developers, application developers, network engineers, server administrators, system analysts and testers.
• Configuration, customization and administration of Oracle
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.

Environment: DB2 iSeries, iSeries Navigator, Microsoft SQL Server 2008/2012/2014 /2016 , SSIS 2008/2012/2014 , SSAS (Tabular) 2014/2016, Visual SourceSafe.

Confidential

Oracle Database Administrator

Responsibilities:

• Install, configured, and maintained Oracle 10g, 11gR2 and 12C.
• Upgrade databases from Oracle 9i, 10g to 11g.
• Responsible for Oracle database security and patching oracle
• Implement Oracle database backup & recovery solutions using RMAN.
• Install, configure, and maintain various flavors of UNIX such as Solaris, AIX and HP-UX
• Experience on creating IBM Support service portal and working with them to resolve issues.
• Installing, configuring, administering and securing test and production servers.
• Create and optimize database objects, e.g. Tables, Views, indexes, cursors, stored procedures, functions, CLR code and Triggers.
• Administer, maintain, develop and implement policies and procedures for ensuring security and integrity.
• Enrolling and mapping users following company policies and procedures.
• Scheduling and automating full/differential/ transactional backups and implementing recovery strategies
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.

Confidential

IBM Agent

Responsibilities:

• Install, configured, and maintained Oracle 10g, 11gR2 and 12c
• Upgrade databases from Oracle 9i, 10g to 11g.
• Responsible for Oracle database security and patching oracle
• Implement Oracle database backup & recovery solutions using RMAN.
• Install, configure, and maintain various flavors of UNIX such as Solaris, AIX and HP-UX
• Experience on creating IBM Support service portal and working with them to resolve issues.
• Installing, configuring, administering and securing test and production servers.
• Create and optimize database objects, e.g. Tables, Views, indexes, cursors, stored procedures, functions, CLR code and Triggers.
• Administer, maintain, develop and implement policies and procedures for ensuring security and integrity.
• Enrolling and mapping users following company policies and procedures.
• Scheduling and automating full/differential/ transactional backups and implementing recovery strategies.
• Configured and monitored database replication as high availability and disaster recovery strategy.
• Upgrading the SQL Server Databases, Monitoring and Performances tuning.
• Developed reports using SSRS, Crystal Reports with T-SQL, MS Excel and Access.
• Developed automated procedures to produce client data files on schedule using Microsoft Integration Services (SSIS).
• Implement data models, database designs, data access and table maintenance codes.
• Installing and monitoring SQL agent jobs.
• Assisting development teams with data cleansing, migration and loading in addition to assisting and supporting development teams with reviewing, building, testing and maintaining database structures and SQL scripts.