| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLE
EMAIL AVAILABLE
Professional Summary:
Eight Plus years of experience in Implementation, Administration and Support of MS SQL Server 7.0/2000/2005/2008R2/2012/2014/2016, Azure and AWS in Development, Test, UAT and Production Environments.
Gathered business requirements and converted it into SQL stored procedures for database specific projects.
Installation and configuration of SQL server 2014/2012/2008/2005/2000 with Health Care, Manufacturing and IT sectors.
Specific hands on experience include administering large and complex Databases, Database Design.
Entity relationship diagram (ERD) development / normalization and physical database schema design.
Develop new processes to facilitate import and normalization, including data file for counterparties.
Created files, views, tables and data sets to support Sales Operations and Analytics teams.
Performed Log Shipping and implemented Transactional and SnapshotReplication as high availability techniques.
Experienced with Change Data Capture (CDC) for insert, update and delete in SQL tables.
Implemented ServiceNow and customized. Migrated data from ITSM to ServiceNow.
Created custom-tailored database backup/restore scripts for Full, Differential and Transactional backups and scheduled jobs for DBA automation task. Upgraded/migrated databases from lower version of database to higher version. Experienced in Migrating data between servers (Oracle, MYSQL, Staging, Data warehouse).
Experience in Database of OLAP/OLTP and Mirroring as disaster recovery solution
Experienced in Encryption of Databases on Master DB level, Table level and column level using self-signed certificates and TDE keys for securing the top priority data.
Designed, Developed, Tested the Tableau Dashboards and Administrating the Dashboards on Tableau Servers.
Experience in performance tuning of Tableau Dashboards using Performance Recorder and Tab jolt.
Expertise in Developing and Extending MS SQL Server Analysis Services 2005 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
Implemented Active / Active Clustering and Active Passive Clustering as a disaster recovery solution.
Implemented Always On Availability Group on Multiple instances on SQL Server 2014 and 2016.
Experience in supporting Very Large databases 4TB and troubleshooting the problems.
Experience with 2008 new concepts like Data Auditing, and Policy based management system.
Experience with 2005/2008/2012/2014/2016 concepts like data partitioning, indexing, DDLtriggers, DMV, DMF
Experience with T-SQL in writing triggers, tables, user defined functions, views, indexes, and relational database models and data integrity, and experiencein migrating SQL Server 2000 to SQL Server 2005/2008/R2.
Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for tuning and monitoring SQL Server performance.
Proficiency in Performance Tuning, Query Optimization, Client/Server connectivity, and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
Experienced in managing SharePoint Servers as Admin.
Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC utilities and Index Tuning Wizard.
Intensive experience in monitoring database performance using SQL Profiler, and the DB s percent log space for all database servers using SCOM and Windows Performance counters.
Experience in Database Backup, Recovery and Disaster Recovery procedures.
Experience in writing Stored Procedures, User Defined Functions, Cursors, Triggers and Schema.
Experience in Data Modeling (logical modeling and physical modeling) using Erwin.
Excellent communication, analytical and inter personal skills and ability to learn new concepts and supported 24/7 on call in production and development environment.
Excellent Communication Skills and Presentation Skills, Comprehensive problem-solving abilities
TECHNICAL SKILLS:
Databases
MS SQL Server 2000/2005/2008 R2/2012/2014, Oracle 8i/9i/10g/12c, MS Access
Tools/Utilities
SSIS, DTS, SSRS, SQL Server Enterprise Manager, Profiler, SQL Navigator BCP, Query Analyzer, SQL Server Manager, SSMS, Apex log, IDERA, ITSM, ASSURENET, Concur, KRONOS, LOFTWARE, Red gate SQL Compare tool, Database Tuning Advisor, Desk Board, Erwin 7.x, Track Wise EQMS, Visual Basic 6.0 & 9.0, ODBC, Excel VBA, ADO, ADO.NET, PL/SQL, TOAD, Visual Studio 2003/2005/2008/2012/2013.
Programming
T-SQL, PL/SQL, C#.net, ASP.net, VB.net, VB Script, HTML, Java Script, Unix Shell.
Ticketing system
ITSM, ServiceNow, JIRA, Remedy.
Operating Systems
Windows NT/2000/2003, Windows 9x, HP-UX 10.x, 11.x, AIX 5.3, Solaris 9/10.
Other Tools
MS Office suite 2000/2003, MS Visio, .Net frame work PHONE NUMBER AVAILABLE
PROFESSIONAL EXPERIENCE:
Bank of America, Addison, TX Jan 2016 till date
MS SQL DBA/Developer, Principal Software Engineer
Responsibilities:
Developed and Optimized Stored Procedures and Functions using T-SQL.
Plan, design, and implement application database code objects, such as stored procedures and views.
Created the schema, implemented all stored procedures and SSIS packages Created the deployment scripts and managed the code in Microsoft Team Foundation Server.
Processed Daily Data Migration through SSIS jobs by collecting data from different servers.
Converted Oracle server databases to SQL Databases using SSMA to reduce maintenance cost.
Maintaining the AZURE portal in creating the databases and archiving the logs and data in AZURE.
Participated in Maintenance activities of AZURE. Writing stored procedures, functions and complex T-SQL queries in AZURE Cloud.
Performed front line code reviews for other development teams.
Experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control.
Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc. and used configuration files and variables for production deployment.
Adept at developing and supporting analysis solutions, data transformations, and reports.
Implemented Always On Availability between Primary and secondary Production servers with configuring Shared Witness server and Windows Failover cluster.
Upgraded SQL servers from 2005 and 2008 versions to SQL 2014 and 2016.
Build clusters 2 node and 3 node with active - active and active passive.
Build dynamic policy models and automated enforcements using Cisco Tetration Analytics.
Processed Telemetry data collections using Cisco Titration Analytics and reduced workloads.
Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
Determined user/business/functional requirements. Created vision, scope, and use case documents;
Experienced in extracting data from Development / UAT / Production servers by using SSIS.
Provide database coding to support business applications using PL SQL, T-SQL.
Design and develop reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
Migrated databases among the servers using copy, attach/detach, copy/restored utilities. Worked on SQL Server Integration Services (SSIS) for data integration from heterogeneous data sources, Adhoc request and ETL related operations.
Secom International Inc, Los Angeles, CA Oct 2015 Dec 2016
Role: MS SQL DBA
Responsibilities:
Experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control
Implemented Encryption of data on stand-alone instances and AOAG instances using Master Keys, TDE and Certificates.
Performed Backup compression using third party tool Delphix.
Performed database maintenance tasks using Third part tool Idera and SQL Monitor.
Upgraded SQL Databases and changed compatibility levels, configured and implemented Always On availability. Generated Scripts for lower version of SQL Server, Changed Compatibility level and data and log file location, executed the scripts using cmd commands.
Created Shared storage, created machine user names to resolve configuration issues in Always On availability setup.
Expertise in mentoring and setting up High availability environment like active-active and active-passive clustering, Database mirroring, Replication (Snapshot, merge, transactional), log shipping, setting up servers from scratch on clustered environment, Linked servers.
Upgraded/Migrated SQL Server 2008/2005 databases to SQL Server 2014/ SQL 2016 databases and mentored Jr.DBAs and other technical staff.
Implemented Data security with Data Masking on SQL 2016 after upgrade.
Implemented Column Stored indexes, Temporal Tables and Memory Optimized tables of SQL 2016.
Involved in Creating the Tableau reports using Tableau Desktop Tool.
Designed views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions. Generated report schedules on Tableau server.
Worked as Tableau architect in standardizing Tableau for enterprise wide deployment.
Created builds in Team foundation Servers (TFS) for deploying Master scripts in UAT ad Production environments.
Monitored Log shipping/ Transactional Replication and trouble shooting of errors.
Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance.
Setup the performance counter by using performance monitor to identify the bottleneck of windows server such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
Captured changes from logs into CDC change tables by enabling CDC stored procedures.
Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc. and used configuration files and variables for production deployment.
Implemented Always On Availability between Primary and secondary Production servers with configuring Shared Witness server and Windows Failover cluster.
Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
Determined user/business/functional requirements. Created vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams.
Configured and implemented SAVIOM project management, after testing ChangePoint and Net Suite Project management and Resource Management.
Responsible for creating and maintaining API interfaces between applications and databases.
Experienced in extracting data from Development / UAT / Production servers by using SSIS.
Upgraded SQL servers from 2005 and 2008 versions to SQL 2014.
Provide database coding to support business applications using PL SQL, T-SQL.
Design and develop reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
Migrated databases among the servers using copy, attach/detach, copy/restored utilities. Worked on SQL Server Integration Services (SSIS) for data integration from heterogeneous data sources, Adhoc request and ETL related operations.
Created reports using SSRS and deployed on to SharePoint Servers.
Digital Intelligence Systems, LLC, San Francisco Nov 2013 Sep 2015
MS SQL DBA/Developer
Responsibilities:
Gathered business requirements and converted it into SQL stored procedures for database specific projects.
Developed various SQL servers and ensured that they were properly maintained and supported
Migrated DTS packages to SSIS Packages and upgraded SSIS packages from SQL 2005/2008 R2 to SQL Server 2012.
Worked with end users to resolve their issues on all applications on priority basis using ITSM tool.
Involved and supported users with ITSM incidents and Change management issues.
Resolved issues on Concur Travel and expenses configuration issues configured Audit rules and Cognos reports.
Worked on inbound and outbound data migrating from AZURE to SQL.
Processed Daily expenses through SSIS jobs by collecting data from Concur FTP servers.
Configured user delegation roles in Concur. Created documentation on HCP recipients for each country globally (complete Spend and Aggregate Spend Projects).
Upgraded SQL Databases and changed compatibility levels, configured and implemented Always On availability.
Responsible for high availability methods like clustering, transaction log shipping, replication, database mirroring.
Performed Tableau Server administration activities like Site and Project creations and adding users and providing permissions to workbooks.
Implemented security in Tableau workbooks by creating filter in workbooks and also implemented security at Data Extraction level.
Used Tableau Admin views to identify the performance issues on the Tableau workbooks.
Implemented Transactional and Snapshot Replication in SQL 2008 R2.
Created Shared storage, created machine user names to resolve configuration issues in AlwaysOn availability setup.
Created reports and deployed on SharePoint Servers. Created users and User roles on SharePoint servers.
Implemented AlwayOn Availability between Primary and secondary Production servers with configuring Shared Witness server and Windows Failover cluster.
Created Master keys and certificates for implementing Data encryption on secured data.
Looped cells, variables and created macros using Excel VBA.
Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
Determined user/business/functional requirements. Created vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams.
Proposed Kronos upgrade project to Client including SQL server upgrade.
Experienced in extracting data from Development / UAT / Production servers by using SSIS.
Provide database coding to support business applications using T-SQL.
Experienced with Clustering setup and Active Directory in Windows 2010.
Develop new processes to facilitate import and normalization, including data file for counter parties.
Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
Design and develop reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
Migrated databases among the servers using copy, attach/detach, copy/restored utilities. Worked on SQL Server Integration Services (SSIS) for data integration from heterogeneous data sources, Adhoc request and ETL related operations.
The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
GENISYS - General Insurance System, Bangalore India Oct 2011 - Aug 2013
Jr. SQLDBA
Responsibilities:
Involved in updating existing databases of SQL server 2008. Managed database security policy login using Windows and SQL server authentication mode.
Managing databases spread across multiple servers in Production, Development, Staging and Testing environments using SQL 2008 and SQL 2005 on Windows Active- Active Clustered Environment
Experienced in using Data Manipulation Language (DML) for the query and update commands and the Data Definition Language (DDL).
Design and develop SSIS packages, store procedures, configuration files, and tables, views, and functions implement best practices to maintain optimal performance.
Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques. Worked on SQL2008 Data compression and Table Partitioning.
Replicate data from acceptance to QA and production phase.
Automated Maintenance Routines to complete monthly data updates and special maintenance activities for the data warehouse.
Generated reports by using SSRS and provided them on web server Report manager.
Worked with importing flat files and XML files, Share Point, fetched data from other data source like MS Access, DB2, MySQL, Oracle and ETL to the database. Created UNIX shell script to move file across the servers and automation of daily tasks.
Migrated data from MySQL DB to SQL DB using SSIS.
Checked database upgrade advisor for compatibility check for databases before updates.
Performed in place and side by side migration of existing SQL server 2005 user s client critical databases. Also changed configuration of databases, increased physical memory, and enabled text indexes.
Migrated database from SQL server 2005 to SQL server 2008 using utilities i.e. export / import and attach/detach for SQL servers 2008 features.
Created, altered, maintained system roles, Logins and permissions to users on various database objects. Designed role based security to managed users activities, Identified and created constraints on table columns.
Audited database user s using SQL profiler tool and costumed stored procedures and packages. Hide tables columns from the developers and non - technical staff member using views.
Created maintenance plans for database Full, Differential and Transactional backup. Also schedule for rebuild indexes, update statistic and check integrity. Performed restore operation and Point in Time recovery for mission critical databases.
Generated reports by using SSRS and provided them on Share point 2010 Report manager.
Identified long running queries using Desk Board report. Generated XML plan for T-SQL performance. Resolved blocked and locked objects issues. Created new Clustered, Non-Clustered Indexes and constraints to the frequently used tables in application.
Migrated databases among the servers using BCP, attach/detach utilities. Worked on SQL Server Integration Services (SSIS) for data integration from heterogeneous data sources, ETL related operations.
Enabled email notification, linked servers, certificates, symmetric keys for advance database use.
Used DBCC commands, System monitor, Dynamic views, Actual Execution plans as part of trouble shooting and performance tuning.
Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
Involved in Staging Partitions and Usage Based Optimization (UBO) mechanisms for SSAS 2012 and 2008 OLAP databases.
UTL technologies, Hyderabad Sept 2009 AUG 2011
SQL ETL Developer
Description: UTL Technologies Ltd., a UTL Group company, one of India s highly appreciated and widelyrecognized prominent high-end training organization in providing Industry relevant training solutions toStudents, Working Professionals and Corporate houses.
Responsibilities:
Created Data model as per User requirements and studied the source system using Star Schema and Erwin.
Transformed data for adding derived column, sorting of data, merging of data done while pulling data from
SQL Server 2000 to Server 2005.
Migrated data from SQL Server 2000 to Server 2005 using Data Transformation Services (DTS).
Created Databases, Tables and triggers to validate the data to meet the specifications.
Created views and indexed views as required by front end developer for easier implementation.
Created stored procedures and functions to support data storage and manipulation.
Used linked / replicated servers and high-volume data storage.
Converted the DTS Packages into SSIS using Migration Wizards.
Involved in Testing and Debugging the Stored Procedures and T-SQL.
Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer Server.
Designed models in Framework Manager and worked with parameter maps.
Involved in query tuning for increasing the query performance.
Optimized the performance of various stored procedures by redesigning T-SQL queries and changing
connection and server level settings.
Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity
Checks, Update Database Statistics and Re-indexing.
Built test scenarios and test cases (negative/positive) to validate expected outcome.
EDUCATIONAL DETAILS
Masters of science in Information technology and management, Campbellsville University, Kentucky
Bachelors in Electronics and communication engineering, Jawaharlal Nehru Technological University, India |
