We provide IT Staff Augmentation Services!

Sql Developer Resume Profile

PROFESSIONAL SUMMARY

  • Over 10 Years of IT experience in Database Administration, Development and Support of MS SQL Server 2012/2008 R2/2005/2000 in Production, Test/QA, Development and Cluster Server Environments.
  • Proficient in Analysis, Design, Development, Implementation, Testing, and Maintenance stages of Applications and Systems in heterogeneous environments.
  • Extensive worked in Data Warehouse/Data Marts methodologies and technologies as well as proficiency in OLTP/OLAP environments.
  • Expert in ETL Process using SSIS, DTS, BCP and Bulk Insert technics, Involved in creating complex SSIS packages to integrate the data coming from various data sources and also extensively debugged Data Warehouse Analytics logic to ensure the data accuracy is maintained.
  • Exposure in Build, Deploy and Maintain Business Intelligence BI Solutions which includes Integration Services SSIS , Analysis Services SSAS and Reporting Services SSRS .
  • Experience in Dimensional Modeling, ER Modeling, Star Schema /Snowflake Schema, FACT and Dimensional tables and Operational Data Store ODS .
  • Excellent Database backend skills in writing good standard T-SQL and PowerShell scripts, SQL objects creation as per the requirements.
  • Having hands-on experience in SQL Server High Availability techniques and Disaster Recovery DR strategies including Replication, Log Shipping, Database Mirroring, Always-On with Planning and Security management.
  • Experience in administrative activities comprising Query optimization, Database indexing, Database consistency integrity-health checks, Performance Profiling/tuning using diagnostic tools and utilities.
  • Proficiency and expertise in Internet Information Services IIS , SharePoint, Sitescope, SCOM, Microsoft Windows and SQL Azure Administrations.
  • Handled multiple SQL Instances on cluster environments and performed various operations like SQL Cluster Failover, Network Load Balancer NLB and Hardware Load Balancer HLB . Database Server Migration, Application onboarding Retirement planning and implementation.
  • Indepth understanding about Software Development Life Cycle SDLC process and excellent analytical, programming and problem solving skills.
  • Performed Capacity Planning, provided both long and short term solutions to controlling and managing database growth and space management.
  • Conversant with Microsoft Operational ITIL, ITSM frameworks, standards and process.
  • Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
  • Excellent communication, presentation and interpersonal skills. Strong troubleshooting and organizational skills.
  • 24 X 7 Production applications and systems on call support.
  • Extremely had worked on Tax Data Warehouse TDW in Microsoft Finance IT/BI- CFIT and continuing the service with Microsoft Products Services IT MPSIT presently.

TECHNICAL SKILLS

PRIMARY SKILLS

DBA SQL Server Administration

SECONDARY SKILLS

Data Warehouse DW Microsoft

PROJECT TECH SKILLS

SQL Server, Business Intelligence, IIS, SharePoint Azure Administrations

OPERATING SYSTEMS

Windows 2012/2008 R2/2008/2003/2000/XP/Vista/7/8

RDBMS

MS SQL Server 2012/2008 R2/2008/2005/2000,SQL Azure, Oracle 9i, MySQL

WEB TECHNOLOGIES

IIS 6.x/7.x, SharePoint/MOSS 2007/2010, ASP.NET, .Net Framework, XML, HTML, VB Java Script, ASP, VB 6.0, Web ETL Tools: SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , SQL Server Analysis Services SSAS , Data integrator, Data Transformation Services DTS

DESIGN TOOL

Microsoft Visio, ERWin

DIAGNOSTIC TOOLS

SQL Profiler, Analyzer, Performance Monitor, MDW, Fiddler, LiteSpeed, Weblog Expert, Netmon, Log Parser, PSSDiag, SQLDiag, Cluster Validation Wizard, SQL Nexus, PerfAnalyzer, Performance Data Collector PDC , Activity Monitor, NLB

Config Checker Diag, AVICodeIntercept etc.

MONITORING TOOLS

Sitescope10x/11x, MOM, SCOM, Windows NT Batch Jobs

NETWORK TOPOLOGIES

TCP/IP, DNS, WINS, DHCP, FTP and SMTP

INFRASTRUCTURE

Cloud Technics Windows Azure, VSS, VSTF, VM-WARE

LANGUAGES

T-SQL, C , PowerShell, C C

DOMAIN KNOWLEDGE

E-commerce, Banking, Telecom, ERP CRM and Finance IT

PM FRAMEWORKS

IT Service Management, SIX Sigma, ITIL V3, SDLC , Agile, PMP Trained

ACHIEVEMENTS

  • Received ASM Award of Excellence in Valuable Contribution and Project Service Delivery from Microsoft at Mahindra Satyam Tech Mahindra .
  • Key Associate Reward and Continuous Star Performer at Mahindra Satyam Tech Mahindra .
  • Received Pat On Back POB from Tech Mahindra on Mahindra Satyam Tech Mahindra .
  • Received Tokens of Appreciations and Rewards from Client - Director, GMs, Service Owners, Stakeholders, and Program Managers of Microsoft on Onsite Offshore at Mahindra Satyam.
  • Key Associate, Highest Revue Generator with Continuous Performer Rewards at IRUS group.

PROFESSIONAL EXPERIENCE

ROLE : LEAD SQL DBA / CLIENT ORDINATOR

Confidential

ENVIRONMENT:

Windows Server 2003/2008/2012, MS SQL Server 2008/2008R2/2012, IIS 7.x, SharePoint 2007/2010, Sitescope 10x/11x, PowerShell, Cloud Windows/SQL Azure , VSTF etc.

  • Manage around 40 CSS/ES applications and responsible for more than 150 Critical Production Servers belonging to supported applications systems globally.
  • Maintain and health Monitor Production, Pre-production Development database Server environments.
  • Participation in Root Cause Identification, Bug fix Problem Management PBM Analysis.
  • Post mortem for critical and complex incidents that impact availability. Troubleshooting and Solving tickets on daily Basis for Production/UAT Issues in Microsoft Product Service IT MPSIT Space.
  • Having hands on experience and perform daily operations includes advanced DBA activities
  • Database Mirroring, Transactional Replication, Backup/Recovery, Disaster Recovery planning using both native SQL third party technologies like LiteSpeed, Rebuilding indexes offline/online at regular intervals for better performance. Active-Active and Active-Passive Clustering on multi node cluster. Various resource allocation memory issues, Configure Email Notifications via SMTP to get Alerts, Database growth estimation and space management. Database performance analysis and ongoing maintenance tuning to ensure performance improvements.
  • Handling Incidents/Service request escalations from various sources Business, and Peer Teams . Ensure first/second/partners team analysts are correctly prioritizing their work.
  • Maintenance tasks such as IPAK's, Account Maintenance Passwords , Certificates, Periodic Audits Servers, Backups , Several Release, Migration and Deployment activities etc.
  • Perform Systems and Operations Management on various platforms along with Network, Domain, Firewall, Cluster, NLB, HLB and other appliances for MSIT Internal applications and Infrastructure hosted on IIS, SQL, SharePoint, Windows/SQL Azure and Terminal Servers with respect to applications and systems in MPSIT.
  • Coordinate with different teams such as Engineering, Test Quality, Service Build Engineering SBE , Infrastructure Management Teams-ServerIM, SQLIM, NetIM, ISM Global Change Operation GCO for any kind of initiative, enhancement, release operations, hardware software upgradation and migrations activities, other key areas on Production/UAT environments as per the requirements.
  • Proficient on the Sitescope and SCOM Managements to create, maintain the groups, monitors and setup the alerting mechanism and also take care of end- end accountability.
  • Being an active team player attending the Demo, Meetings, Training Sessions, Major Incidents on priority with effective communication skills and collaboration by engaging various teams including technical, program management, and user supports.
  • Assist Offshore team and provide Best practices, Answer technical queries, Prepare documentation like Operation Guides, Knowledge Base Articles, Application System architecture diagrams, Periodical review of functional documents etc.

ROLE : SQL DBA

Confidential

ENVIRONMENT: Windows Server 2003/2008, ASP.net, .Net framework, IIS 6.x, MS SQL Server 2008R2/2008/2005, SSIS, SSAS, SSRS, MS Visio etc.

  • Performed several ETLs for data loading operations and analysis monthly based on fiscal year on Tax Data Warehouse TDW .
  • Analyzed the encountered issues during the ETL Operations and taken necessary actions for rollback operations if needed.
  • Monitored daily Batch Jobs, Investigated by taking necessary actions on SQL Jobs, DTS and SSIS Packages during the failures at every stage.
  • Performed daily DB activities on various servers which include Creating Logins and Roles with appropriate permissions, Database consistency, Integrity and Health checks, Database Backup and Restore strategies, Space management, Performance tuning Performance tuning, and also involved on server, database and data migration activities.
  • Debugged on various Production and UAT requests/issues of users related to CFIT-Treasury, Tax and Audit applications systems.
  • Performed regression testing on deployed SSIS Packages, other utilities in pre-production environments and uncovers any issues during testing phase.
  • Refreshed data periodically from DEV to Staging and Staging to Production environments.
  • Executed Extract, Transform, and Load data from heterogeneous data sources to SQL Server. Import data across multiple instances using BULK INSERT and BCP Utility.
  • Migrated Databases from SQL Server version 2005 to 2008.
  • Created Maintenance plans, Update Statistics to improve performance, Rebuild indexes to reduce the fragmentation in 2008R2, 2008, 2005 environment.
  • Expert in Performance Tuning, Analyzed long running queries and tuned them to optimize the system performance.
  • Used Perfmon, DMV's, SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.
  • Written T-SQL queries, Created Views, Stored Procedures, Clustered and Non-Clustered
  • Indexes. Debugged, Fine-tuned the Stored Procs, SSIS DTS packages.
  • Involved in Capacity Planning, Database Normalization and De-normalization process.
  • Involved in Logical and Physical Data Modeling process using MS Visio.
  • Performed Password reset activities for Services, Application Pools, SMTP, COM , NT Jobs etc. on various servers and verified through smoke test on completion.
  • Involved with Engineering team on several ETL Automation process for Data loading operations on TDW, Validated the packages in pre-production environment, uncovered any issue during testing phase/cycle and provided the feedback to Engineering team for enhancement.
  • Created Operational documents and high level architecture diagrams for operations purpose.

ROLE : SQL DEVELOPER / DBA

Confidential

ENVIRONMENT: Windows Server 2000/2003, MS SQL Server 2005/2008, MySQL, DTS, SSIS, SSAS, SSRS, ETL, T-SQL, SharePoint, Crystal Report, IIS 6.x, .Net framework, Asp.net, C , XML, VSS etc

  • Involved in Requirement Analysis, Design, Development and Testing phase.
  • Installed and configured SQL Server 2000 2005 components in Development and Production servers and applied service packs hot fixes.
  • Maintained various databases on Production, UAT and Development environments.
  • Migrated the databases from various systems SQL Server 2000, 2005, Oracle, and MySQL .
  • Performed the deployment activities in different client place remotely and solved the issues during deployment phase.
  • Performed daily DB activities on various servers which include Database consistency, Integrity health checks, Index tuning, backup and restore strategies etc.
  • Maintained Transactional replication, Database mirroring, Logshipping on production servers.
  • Monitored server performance using SQL profiler, dead locks, blockings and capturing long running SQL queries, fine-tuning SQL objects for better results and efficient processing.
  • Written T-SQL scripts, Designed and created Databases, tables, views, indexes, stored procedures, functions, triggers, batch jobs, created complex reports using crystal report SSRS, Error handling mechanism as per the business requirements.
  • Managed SQL databases, security, created user accounts / logins for development purpose and implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Performance tuning and testing SQL objects like stored procedures, indexes and triggers using Database Tuning Advisor DTA and SQL profiler.
  • Extensive testing to improve the performance of database objects and developed products.
  • Prepared and enhanced the projects, coding guidelines documents for SQL Web developers.
  • Visual Source Safe VSS 6.0 Administration.

ROLE : SQL DEVELOPER / DBA

Confidential

ENVIRONMENT: Windows Server 2000, MS SQL Server 2000, T-SQL, DTS, Oracle, MySQL, Crystal Report, IIS 6.x, .Net framework, Asp.net, C , XML, VSS etc.

  • Involved in Requirement Analysis, Design, Development and Testing phase.
  • Installed and configured SQL Server 2000, Software, Tools Utilities in Development and Production servers.
  • Migrated the databases from various systems SQL Server 2000, Oracle, and MySQL .
  • Performed the deployment activities in different client place remotely and solved the issues during deployment phase.
  • Performed daily DB activities on various servers which include Database consistency, Integrity health checks, Index tuning, backup and restore strategies etc.
  • Handled various requests/issues of users related to applications, production servers and databases.
  • Written T-SQL scripts, Designed and created Databases, tables, views, indexes, stored procedures, functions, triggers, batch jobs, created complex reports using crystal report, error handling mechanism as per the business requirements.
  • Created DDL and DML commands through command line tools OSQL as well as GUI tools Query Analyzer, Enterprise Manager, Management Studio, etc.
  • Managed SQL databases, security, created user accounts / logins for development purpose and implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Used Performance monitor, SQL Profiler and Execution plan to optimize queries and enhance the performance of database servers and to solve long/slow running Queries.
  • Involved in optimization fine-tuning , debugging the database objects.
  • Visual Source Safe VSS 6.0 Administration.

Hire Now