SUMMARY:

• 8+ years of experience as a MS SQL DBA/ Developer in analyzing, designing, tuning, and developing Client/Server and various segments of SDLC, using MS SQL Server 2016/ 2014/2012/2008 & 2008 R2.
• Experience in Installing, Configuring, managing, monitoring and troubleshooting SQL Server, Oracle, and DB2 databases.
• Good knowledge on deployments, Maintenance and troubleshooting applications on Microsoft Cloud Infrastructure Azure.
• Good exposure of OracleDBAtasks like Installation, Patching, Cloning and Upgrade of Oracle Databases like Oracle 10g and Oracle 11g.
• Extensive knowledge in tuning T - SQL (DDL and DML) queries to improve the database performance and availability.
• Experience in dealing with the issues related to High Availability Techniques such as Log shipping, Mirroring, Replication (Transactional and Snapshot), clustering and Always on.
• Expertise in Security Issues such as creating logins and granting permissions on various objects as well as Administering security for server logins regularly (Windows and SQL Accounts) and guest user logins.
• Having good administration experience on the Postgre SQL database.
• Proficient in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to facilitate efficient data manipulation, data consistency and complex business logic using Batch Files.
• Good experienced in ETL tool Ab Initio in using GDE Designer. And JSON .Very good working experience with all the Ab Initio components.
• Expertise and well versed with various Ab Initio Transform, Partition, Departition, Dataset and Database components.
• Experience with Ab Initio Co-Operating System, application tuning, and debugging strategies.
• Having good writing UNIX Shell Scripts including Korn Shell Scripts, Bourne Shell Scripts.
• Experience in dealing with the issues related to the Backups (Full, Differential, Transaction Log, Tail Log, Copy Only and Striped Backups) and restoration related issues.
• Expertise in database optimization using tools like Index Tuning Wizard, SQL profiler, File groups, DBCC utilities and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Experience with third-party monitoring and backup tools such as Red Gate, litespeed and Idera.
• Experience in maintaining database, including updating statistics, re-indexing, structure modifications, and index analysis.
• Hands-on experience in resolving locks deadlocks, handling Isolation levels and performance issues like CPU, I/O, Memory bottlenecks.
• Used SSIS as an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Experience on SSIS as an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Experience in Operational and Analytical Report development using SQL Server Reporting Services (SSRS) including Dash boards and Scorecards.
• Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators withSQLServer Agent, handling Backup/Recovery of databases, Replication, Linked Servers, and Database Maintenance.

TECHNICAL SKILLS:

• Microsoft SQL Server (2016,2014, 2012, 2008R2, 2008, 2005), SSIS, SSRS, crystal reports, Microsoft Visual Studio 2008/2010/2013, T-SQL, PowerBI, ETL, PowerShell, Oracle Database, Microsoft Power BI, ASP.net, c#, SharePoint 2010, TFS, VSS, Windows 8, Windows 7, Windows XP, Windows Azure, ITSM, Service Now, Data Warehouse.

WORK EXPERIENCE:

Confidential - Auburn Hills, MI

Sr. MS SQL DBA/ Developer with Azure SQL

Responsibilities:

• Involved in SQL Server Configuration, Administration, Implementation and Trouble-shooting for Business work.
• Involved in Migration of Databases from SQL Server 2008 R2 to SQL Server 2012
• Used SQL Profiler for Performance monitor to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels
• Performed Database Refresh tasks from production to Development and Staging Servers
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Up gradation of System Configuration.
• Planned, Configured, Installed, Maintained SQL Server in environment of Multi-Node Cluster with Multi-instances.
• Monitoring and troubleshooting MS SQL Server Databases, Oracle databases and DB2 databases.
• Setup and troubleshoot for Active/Active/Passive Clustering in SQL Server 2012
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Work involvement in performance monitoring of Memory, Processor, Disk I/O and fine tuning.
• Controlled, coordinated installations (Security Patches, Service packs) and evaluated the performance before deployment.
• Involved in daily code drops and archives on the production databases during maintenance windows.
• Installing and configuring nagios check postgresql.pl plugins for Monitoring PostgreSQL instances effectively.
• Proactive in updating the latest security patches to database, which are provided by PostgreSQL open source community.
• Worked on CI/CD forPostgreSQLandMySQLApplications.
• Performed Regular Database Maintenance process, checking the disk Defrag procedures in different environments.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Database Performance of Index tuning with using Database Engine Tuning Advisor to resolve Performance issues.
• Configure and manage database servers, including monitoring ofsystems health and performanceand ensure high levels of performance,availability, and security.
• Analyze data modeling techniquesto ensure efficient development and implementation.
• Independently analyze, solve, and fixissues in real time, providing problem resolution and support end-to-end.
• Automate regular processes, track production issues and document changes Design, Implement and support BIand DWH environments.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
• Developed, deployed, and monitored SSIS Packages.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008.
• Developed a java web application using the Struts 1.0 Framework.
• Created Java Extensions to convert files into other files formats.
• Retrieve data from database to create reports in java using Aspose.
• Design, develop and maintaindata warehouse, reporting databases.
• Support business intelligence environment and schema to support the reporting needs of various business users.
• Implementdevelopment life cycleusing release management tools like TFS (Team Foundation Server).
• Performed in identifying the sub-optimal solution for code in production server with SQL Trace Analyzer.
• Excellent knowledge and hands on experience in Migrations from on-premise to Azure IAAS and PAAS servers.
• Having very good knowledge on Pricing models of DTU/eDTU vs Vcore Model.
• Having good experice into Geo-Replication, Avialabilty Group(s) and Data Sync
• Implemenetd Data Partitioning, Purging and Archiving solutions in the Azure model databases
• Having very good knowledge on saving the cost on Azure models
• Deploy, Configure, Maintain Compute on Azure IAAS and PAAS servers
• Troubleshoot Azure related issues and engage internal teams and vendor issue resolutions
• Automate deployment and troubleshoot mechanisms for quick service.
• Create and configure Logical SQL servers, databases, elastic pools in Azure Cloud.
• Monitor performance and setup alerts to avoid performance issues occurring on Azure databases.
• Having hands on experience in Elastic Jobs and Run Books.
• Having good knowledge on External tables and Elastic pool Model(s)
• Having hands on experience into the Reservations and Azure hybrid benifits
• Import and Export data within Azure Cloud environment.
• Deployed Active Directory domain controllers to Microsoft Azure using Azure VPN gateway
• Creating and Managing logins/Access levels in Azure IAAS and PAAS environments.

Environment: SQL Server 2014/2012/2008, SQL Profiler, High availability, Performance monitoring.

Confidential - GRAND RAPIDS, MI

MS SQL Server DBA/developer

Responsibilities:

• Installed SQL Server 2014/2012/2008 R2/2008 on Windows Clustered and standalone environments with latest service packs.
• Working with customers on Application rollouts and server migrations.
• Implementation ofSQLLogins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Setting up and Monitored transactional replication, Database mirroring on Production, QA and Dev servers.
• Monitored Log shipping/ Transactional Replication and troubleshooting errors.
• Configured Backups, optimization jobs and involved in restoring database to point in time in case of issues, troubleshooting long running queries, locks, deadlocks and performance issues.
• Worked in active/active and active/passive cluster environment
• Job Monitoring and making sure all jobs run successfully every night.
• Performed Database backups with tools like litespeed.
• Migrate PostgreSQL 8.4 database to PostGreSQL 9.1 database using pg dump and pg dumpall
• Migrate Oracle 9i database to PostGreSQL 9.1 database using ESF Database migration toolkit.
• Created SQL queries for diverse usage ensured integrity of data with frequent restoration and back up using pgAdmin 4.1, PostGreSQL.
• Developer and administrator of Socio-economic application using PostGreSQL, PHP, Java, HTML, XML, pgAdmin 4.1, ireport.
• Developer of electrical equipment database of SONABEL Energy company using Perl Bash Scripting, PostGreSQL 9.1,
• Developer of and improvement competencies database of SONABEL Energy Company using Perl Bash Scripting, PostGreSQL 9.1.
• Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio and SQL Server Agent.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages and stored procedures.
• Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS.
• Created dashboards in VSTS for CI/CDpipelines, Work items and bugs.
• Experienced in procuring and setting up Azure SQLDatabase
• Experience in Migrating SQL Server databases to Azure cloud platform.
• Involved in improving SQL Query performance by analyzing the query using Execution Plans and modify queries by using appropriate joins.
• Schedule Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.

Environment: SQL Server 2014/2012/2008, SQL Profiler, High availability, Performance monitoring.

Confidential

SQL Developer/DBA

Responsibilities:

• Responsible for installation and configuration of SQL server 2014/2012/2008 databases on windows2008/2012 servers.
• Administered MS SQL Servers by creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups
• Involved in creating Databases, Tables, Clustered/Non-Clustered Index, Unique/Check Constraints, Views, Stored Procedures, Triggers, Functions and Defaults
• Performed SQL Server DBA role with support to the SQL Server standalone and cluster environments.
• Based on the business need created all three replication models on different applications.
• Developing SSIS Packages and load new tables for any kind of enhancements to the existing reports.
• Performed Database Integrity Checks, updated Database Statistics and performed re-indexing daily Interact with various departments for new release and troubleshooting of applications
• Responsible for migration and support of databases for Production, Integration and Development environments
• Proactively monitored the database health through automated scripts for checking the database and extents growth, probing the alert log files, monitoring the rollback segments and temporary space usage.
• Troubleshooting Stored Procedures and Queries performances using SQL Server Profiler, Performance Monitor, DBCC Commands and Dynamic Management Views (DMVs).
• Updating and maintaining all the SQL Process documents

Environment: SQL 2012 / SQL 2014 / SQL 2016, COSMOS, PowerBI, ISCOPE, USQL and SSIS

Confidential - Dallas, TX

SQL Server Developer

Responsibilities:

• Performed Installing and MaintainingSQLserver as required and configuration ofSQLserver services and TCP/IP protocols.
• Setup and scheduled full and transactional log backups for the user created and system database in the production environment using the Database maintenance plan wizard.
• Perform DBCC commands to troubleshoot issues related to database consistency.
• Implemented indexed views to increase the query performance.
• Implemented high availability solutions for mission criticalSQLServer databases with clustering and Mirroring onSQLserver 2012
• Configured Merge and Transaction Replication from Production to DR Servers and Reporting Server with Multiple subscribers onSQLserver 2012.
• Installed and configuredSQLServer 2012 on Standalone and Clustered Environments.
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Performed Back-up, Restoration of Databases in Full Recovery &Bulk-Logged modes.
• Proactively monitored the database health through automated scripts for checking the database and extents growth, probing the alert log files, monitoring the rollback segments and space usage.
• Resolved the issue of mission critical of high usage of system CPU, Disk, Deadlocks issue and Transaction per/sec, Memory involved in performance monitoring of Memory, Processor, Disk I/O.

Environment: SQL Server 2008, Log shipping, DBCC, Performance Monitoring, SQL Profiler.

Confidential

SQL Database administrator / Developer

Responsibilities:

• Implementation of SQL Logins and Authentication Modes as part of Security Policy for various categories of user support.
• Responsible for the installing MS SQL Server 2005 & 2008, configuration and performance tuning.
• Created and maintained various databases for Production, and Stage Servers. Planning the location of data, index, and Transaction log files on the disk.
• Recovering the database from backups in disaster.
• Designed and implemented Disaster Recovery site usingSQLSERVER Log Shipping.
• Involved in Database Maintenance, Releases, created SQL Agent jobs, Alerts.
• Maintaining the database consistency with DBCC at regular intervals.
• Database Management like adding secondary files, expanding file sizes, and shrinking data files when we get Space issues.
• Backup/ Restore, Automated DBA activities, Created and Scheduled the SQL Agent jobs, Alerts, Database Mail.
• Solving the issue based on user complains regarding slow performance issues

Environment: SQL Server 2005, Windows 2008 Server, T-SQL.