PROFESSIONAL SUMMARY:

• 10+years of widespread experience in a Data - world as SQL Database Administrator, Databases Architect/ Developer, BI Developer integrating applications and Data (ETL/SSIS) and as SSRS report writer. Innovator in DevOps team structure. NoSQL on MongoDB. Worked in VMware to troubleshoot and address server-related tasks.
• As Databases administrator - Installing and configure SQL servers with components (SSIS, SSRS, SSAS) on Physical and Cloud with best practices on clustered and standalone. Migrating databases/Apps from old servers to a new version. Design topologies, setup and manage high availability (Disaster recovery) like AO Availability groups, Cluster, mirroring, log shipping and replication. Create and deploy backup and recovery solutions across enterprise servers with 24*7 recoverability. Troubleshoot job/process failures, identify performance issues, index, and stats optimization. Monitor Server health by creating proactive alerts and correlate usage data from VMware. Patch and upgrade. Clone server and databases to Test/Dev environments and mask sensitive data. Set up cross platform connectivity to databases. Tightening data security and control permissions granularly for different groups/users. Audit permissions for sensitive databases. Perform code reviews, identify potential issues for scalability. Perform automated and manual deployments. Support production operation24*7. Automate routine process (with PowerShell, cmd).
• As Databases Architect/Developer - Gather requirements, logically envision the architectural design and translate logical models into physical implementation of Databases/DW. Develop complex Store procedures, functions, triggers and all sort of objects in databases that supports the current business and be scalable as the data size grows. Analyze the current structure and modify for better performance and to keep up with the business needs. Build solid process that feed tailored data to-and-from Application including on Snowflake.
• As BI Developer/ETL/ Report Writer - Design/Unit test SSIS/ETL packages that processes large volumes of data to extract, transform, validate and load data to destination. Maintain and enhancing ETL processes. Customized and transfer data from OLTP and different sources to OLAP data warehouse for different consumptions. Create the complex query/Store procedure and use various visualizing tools, SSRS, Power BI to design eye-caching dashboards and various sort of reports (Parametrized, Drill through/down) dynamically changing reports. Work with various data sources to feed and send data to be used directly by clients and applications. Build and deploy BI solutions. Setup Report Server from ground-up and maintain security/permission for different users and groups. Manage/Migrate numerous reports to newer server using PowerShell. Use other integration tools (IntApp) to connect across different application/platforms to execute process and integrate data.
• Generally, an end to end databases expert on MS SQL, Oracle, MySQL, Snowfalke, Postgres, DB2 and other RDBMS technologies and expanding to big data world like MongoDB. Team player, self-starter able to be upto speed quickly able to learn and work with new apps. Work as one-man team and able to meet deadlines and satisfy user/client requests as expected.
• SSMS, SQL, SSIS, SSRS, PowerBI, Talend, Activebatch, VMware, VSphere, Redgate, Spotlight, Solar winds, SnowFlake,PostgresDB, WhatsupGold, MySQL, Oracle, Visual Studio, IBM MQ,DB2,Profiler, Access DB, XML, JSON, Linux, MS Server
• Windows 95/98/XP/ 2000/2003/2008 Server, Red Hat Enterprise edition, can work with other flavor of Linux versions.
• Environment: SQL Server 2005, SQL Server 2008, Query Analyzer, Windows 2000/XP, Profiler.
• Spotlight DBA monitoring tool. CMD, PowerShell
• Jira, Confluence slack, MS Lync(Video).
• Preparing technical documentation, attend meetings with external clients.
• Working with IIB V. 9 to transform different message formats (To and From COBAL, XML, MRM) with WebSphere Message broker (IIB) to send and receive messages.
• Concept of Hadoop.
• Creating and working with Web services on IIB.
• Strong understanding of the full Software Development Life Cycle (SDLC) with different models.
• Working in Agile, SLDC sprint, scrum meetings and waterfall models.
• Experience MS Visio for data modeling. Develop services and message flows using different nodes.
• Work with MQ to create and manage different types of Queue and objects.Computer OS troubleshooting.

PROFESSIONAL EXPERIENCE:

Confidential

Database Admin/ Reporting,BI

Responsibilities:

• Migrate more than 500+ databases in multiple 2008 SQL servers along with applications, SSRS reports and related Components to 2014, 2016 and 2017 SQL versions.
• Envision, develop, unit test, document, schedule, & deploy supportable technical solutions to business and maintenance needs.
• Deploy a backup and recovery Solution on enterprise level and create appropriate alert and reporting mechanism.
• Tighten security of sensitive data and regularly auditing for security flaws.
• Patch SQL and operating systems to the latest releases.
• Install SQL on Standalone and clustered environment and setup Availability groups.
• Migrate databases from on prem to cloud, premise to Premise and also Setup databases on cloud environments.
• Deploy and maintain IIS web-based application that connects to SQL databases.
• Use CMD and PowerShell scripts to automate processes and create Pro-active alert processes
• Use PowerBI and SSRS to create dashboards and different dynamic reports such as drilldown, drill-through, parameterized.
• Implement and test disaster recovery scenarios for minimizing RTO and meeting RPO.
• Monitor and manage server-side issue, add resources, clone on VMware VSphere
• Maximize performance through ongoing and ad hoc database and system analysis
• Use integration software to integrate data to/from different application.
• Clone prod server to DEV and TEST as requested.
• Use PowerShell to automate routine tasks and for DBA works. Work with DTSand BCPdata transformation.
• Work on Snowflake database.
• Monitor and take action whena databaserun in to low performance issues.
• Migrate databases and convert processes to run on Cloud (RDS)
• Work in disaster recovery andOperationalSupport team/production level issues.

Confidential

SQL Server DBA/Developer/Data Engineer

Responsibilities:

• Administer all version and components (SSIS, SSRS & SSAS) of SQL servers .
• Install and configure SQL server in AWS cloud environments (PaaS) and migrate databases to cloud.
• Work as Innovator to design, develop and maintaining flow of processes.
• Work with SSIS/ETL with all tasks and make a dynamic flow of the packages and data integrations.
• Design, translate and automate reporting and BI databases on SQL Azure.
• Create and Maintain several processes that run across multiple servers for various application like salesforces, PeopleSoft, IBM integration Tools …. etc.
• Work with the finance team to automate and visualize loan and sales related workflows
• Troubleshoot SQL agent job failures. Solve different bugs from SSIS,SSAS and reports.
• Set up different DR strategies for Different systems and versions, High Availability,
• Support and integrate SQL with different APPs by developing suitable PL/SQL complex codes that will be executed on another platform like PeopleSoft, Salesforce, EPM…
• Patch all version of SQLservers ( ) on different operating systems.
• Follow and standardize all Databases are according to enterprise standards and check and correct all deployments if they are according to the standards. and mask sensitive databases
• Design, develop and maintain reports that arecreated forinternal/externaluser and App facingreports.
• Control access to the appropriate user and groups on databases and Reports.
• Upgrade SQL server to the new version and Convert allPackagesand all related objects to fit thelatest version.
• Create link servers across SQL servers and control the permission via the link.
• Automate Agent Jobs in different servers without creating link servers.
• Set up and test DR strategies for different databases that supportapplications.
• Encrypt, Mask and obfuscate sensitive and private data in QA/Dev and Test databases.
• Truncate log files to keep the server withsufficient disk space. Work with table index. Table partitioning.
• Keep databases with a clone copy for a smooth CI/CD, Continues deployment/TFS.
• Create Synonyms to cover up targeted objects and that exited local servers and DMZ servers.
• Manage daily Backups for all production servers and monitor maintenance. Backup and restore as needed.
• Manage databases on MySQL. Create and maintain DB objects in oracle 10g
• Work on Oracle Database that supports front end application.
• Communicate and feed data from and into Oracle database.
• Earn and recognition for introducing efficient way of processing options

Confidential

SQL ServerDBA/Developer

Responsibilities:

• SQLServer (2005/2008/2008 R2/2012 and 2014)as DBA for more than 60+ productiondatabases across different servers for different processwith an estimate of more than 50 TB compressed data.
• Monitor and troubleshoot around 600+ SQL Agent jobs.
• Work in disaster recovery andon call rotation toSupport production issues.
• Watch closely and plot alarm on production DB on differentwait typesandavoidbottlenecks.
• Create a Snapshot and keep databases synchronized on periodical time frame.
• Make sure import and exportprocesses are successfully executed on time.
• Creating and Supporting legacy DTS/SSIS packages. Work with DTSand BCPdata transformation.
• Tuning up poorly written Store procedures and work with indexes and related issues to increase performance.
• Responsible for a daily process that transfer datafile timely for clients with the correct dataset on the agreed file format.
• Monitor and set alerts on failed and successful process and any activity that has pressure on SQL server and CPU.
• Developedrelational tables,writing adhoc queries, joins, stored procedures, views, user-defines functions etc.
• Monitor,detect and troubleshoot SQL Server related CPU, memory related issues.
• Aware of potential blocking, deadlocking and other day to day routines and design to avoid thosepressures on the server.
• Create login/role the necessary granular permissions for different groups. and resolve any issue from the automated jobs and cover the DBA responsibilities 24/7.
• Identify a good candidate for index in a schema. Track down the slowness of executions on tables and deal with index and defragmentation.
• Used various SSIS (ETL) data flow tools to transformation, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data to destination database.
• Troubleshoot SSIS packages on errors occurring at execution and make sure the job is completed successfully.
• Pinpoint root cause of performance, Tuning techniques to improve the query/processperformances.
• Participate in development and creation of Data warehouses.

Confidential

SQL Database Dev/Admin

Responsibilities:

• Experience in installing, creating, and maintaining database objects inSQLServer 2005/ 2008/R2 and Oracle.
• Designed logical and physical models that supports (CCMS)application.
• Create, modify and maintain tables, views, stored procedures, user defined functions and other database objects;
• Writing,debugging,andoptimizingdatabase objects for better performance and function.
• Used joins, sub queries, correlated sub queries and derived tables in views, stored procedures and functions to meet business requirement.
• Created database triggers to implement business requirementsensuring data integrity is always maintainedwith the use of Data Manipulation Language (DML) and Date Definition Language (DDL)
• Write complex code, test and implement solutions using SQL Server 2008R2 and 2012 and on DB2.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databasesfor reporting and otherrequirements.
• Design develop and code various T-SQL queries, stored procedures and functions to support front-end applications.
• Developing index and constraints on database structures to enhance performance and integrity, respectively.
• Designed ETL process to load data from different sources likeExcel, Flat Files,CSV files, Oracle etc.
• Extracting, Transforming and Loading (ETL) of data with SQL Server Integration Services (SSIS) from various platforms (SQL, flat files, excel, etc.).