We provide IT Staff Augmentation Services!

Sql Developer Resume Profile

3.00/5 (Submit Your Rating)

PROFESSIONAL PROFILE:

  • Over 13 years of experience in IT of which more than Seven years as Database Developer and Production DBA.
  • Experience in installing, configuring, performance tuning, setting up and managing transactional replication, client/server connectivity, query optimization, back-ups, running Database Consistency Checks using DBCC of SQL Server 2005/2000/7.0.
  • Experience in Migration of SQL Server from 2000 to 2005/2008/2008R2/2012.
  • Experience in Database Normalization and De-Normalization.
  • Experience in designing and maintaining Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.
  • Experience in Debugging complex Stored Procedures and Triggers, Troubleshooting database issues.
  • Extensive experience in Query Tuning by using SQL Profiler, execution plan, Trace, statistics, index tuning wizard.
  • Experience in ETL Tools like Data Transformation Services DTS , SQL Server Integration Services SSIS , Bulk Copy Program BCP .
  • Experience in Data Transfer to and from SQL Server with various hybrid data sources like XML, Flat File, Excel, 834 files.
  • Good knowledge in Clustering both Active/Active and Active/Passive environments.
  • Extensive experience with production DBA activities that include Replication, and Log shipping, Backups, Performance Issues, Connectivity to databases, Upgrade Strategies, Tuning of Parameters.
  • Expertise in implementing and setting up DISASTER RECOVERY and HIGH AVAILABLITY solutions like Log Shipping, Mirroring and Replication Transactional and Snapshot Replication
  • Extensive experience in creating and optimizing T-SQL queries, Stored Procedures, Views, Cursors, Functions and Triggers on SQL Server 2000/2005/2008/2008R2/2012.
  • Expertise using Business Intelligence and Development tools: Analysis Services SSAS , Reporting Services SSRS and Integration Services SSIS to manage data warehouse environment
  • Deployed and Debugged SSIS packages for import, export and bulk inserting data with transformations from various data sources
  • Monitored and tuned application using the performance Diagnostic tools such as SQL Trace files.
  • Experience in using Performance Monitor to resolve System Hardware bottlenecks.
  • Good experience with database Consistency Checks using DBCC utilities.
  • Created Maintenance Plans to perform index defragmentation, re-indexing and update the index statistics.
  • Experience with creating Jobs, Alerts, SQL Mail Agent and schedule DTS Packages.
  • Experience with Database Backup, Disaster recovery and Disaster recovery drill.
  • Experience with implementing DR solution using log shipping.
  • Good experience in handling the entire Database Builds Production, Pre-Prod, staging Development .
  • Experience in Configuring and troubleshooting online indexing and recoveries in SQL Server 2005/2008/2008R2/2012.
  • Provided 24x7 On-Call Support for the Production Database Servers.
  • Team player with ability to adapt quickly highly motivated with excellent interpersonal, communication and leadership skills.
  • Have been rated as a STAR rank in Satyam computer services.
  • Technical Skills:
  • Project Domain: Application Development, Systems Integration and Database Administration of MS SQL
  • Server 2012/2008R2/2008/2005/2000. Databases: MS-SQL Server 2012/2008R2/2008/2005/2000, PL/SQL, Oracle 9i and DB2.
  • Languages: Active X, VBScripts, HTML, XML,PERL scripting, C ,C , VB.net, XML and HTML
  • Operating System: Windows Advanced Server 2003/2000, Windows NT 4.0/XP/Professional
  • Tools: MS Office 2000/2003, MS Excel 2000/XP/2003, MS Outlook 2000/2003, Erwin,
  • MS Visio.

Professional Experience

Confidential

SQL Server DBA as a Consultant

Responsibilities:

  • Created a mirrored database on the report server using Database Mirroring with High Performance Mode
  • Daily monitoring of the database performance and network issues.
  • Performance tuning, and optimization of procedures and queries.
  • Rebuilding indexes on various tables.
  • Worked with SQL server Profiler generates traces.
  • Implemented Normalization principles, logical and physical modeling, database design principles, tuned queries, stored procedures, and provided production support
  • Configured the compatibility levels of the database and updated software, installed service packs, hot fixes in Clustered environment
  • Successfully installed SQL server 2008 in production environment and configure Log shipping..
  • Day-to-day activities like taking backup or schedule the backups daily for database and transaction log on disk and restore the databases and transaction log on production/development servers as per requirement.
  • Helped Development Team in deploying and testing the application, which uses SQL Server backend.
  • Migrated DTS 2000 packages into SSIS and maintained the archival data using Control flow task
  • Monitoring SQL server LOGS, Application logs and analyzing the logs.
  • Connecting SQL servers remotely using Terminal services.
  • Created new Tables, STORED PROCEDURES and Triggers in T-SQL
  • Responsible for the Installation of SQL Server 2005/2008 Enterprise Edition in Production, Development.
  • Applied service packs, Patches and hot fixes.
  • Implemented the disaster recovery models like mirroring, log shipping and transactional replication.
  • Granted roles and permissions to SQL server users.
  • Created maintenance plans, scheduled jobs and SSIS packages.
  • Generated reports in SSRS using BIDS Business Intelligence Development Studio
  • Performed Database backups- Full, Differential and Transaction log.
  • Daily tasks included Troubleshooting performance issues: deadlocks, blocking, memory, I/O, disk and network bottlenecks, and also monitored space requirements, and file growth, and also security issues, and fixed orphaned users, managed logins
  • Created alerts and notifications for system errors, insufficient resources, and fatal database errors.
  • Used SQL Profiler for troubleshooting, monitoring, tuning of SQL Server and SQL code.

Environment/Software:

SQL SERVER 2008/2008R2, SQL server management studio 2008/2008R2, BIDS SSAS,SSRS,SSIS , Java, JavaScript, XML, VB.Net, Micro Focus COBOL, Centura/Gupta SQL, WINSCP, Batch Daemon, T-SQL, PVCS, Tracker, Bugzilla and Visio.

Confidential

SQL Server DBA as a Consultant

Responsibilities:

  • Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in customer acceptance of the results.
  • Responsible for participate in customer meetings on different requirement baseline.
  • Batch job support, Creating batch jobs for the retail business use.
  • Developed batch jobs for Daily and Monthly run. Fixing production abends based on priority.
  • Extracting data from SQL server, manipulating data using Perl uploading into Oracle thru AQT.
  • Developed, deployed and monitored SSIS Packages for on-going ETL Processes.
  • Designing cube dimensions SSAS and Querying MDX
  • Migration of DTS packages to SSIS packages
  • Worked on Report generation using SQL Server Reporting Services SSRS that consumed by marketing department.
  • Implemented Disaster recovery plans and backup solutions
  • Connecting SQL servers remotely using Terminal services for trouble shooting.
  • Responsible for Stored procedure optimization, tuning.
  • Partitioning tables to achieve better performance for access and writes.
  • Perform systems analysis, Design, implementation and maintenance of product modules/subsystems to ensure proper functioning of product and to meet business needs Studies the stakeholder requirements, Develops, construct
  • Develop Test plan, Test cases and perform the unit, integration, system testing and implementation. Develop the product using the software development life cycle methodology.
  • Stored procedures creation and developing new Modulus.
  • Create appropriate Technical documentation and user manuals to ensure that documentation enables more efficient use of product.
  • Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
  • Responsible for meeting or exceeding all defined target goals and milestone dates for the project in order to ensure its overall success.
  • Responsible for task allocation, estimation, review and final delivery of all the deliverables
  • Participated actively in preparations of Logical Architecture and data Design.
  • Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.
  • Finding the Root Cause Analysis for the Production Issues/ABENDS and providing Permanent Solutions. Post implementation support for new/enhancements of the software products.
  • Responsible for Monitoring Incidents/service calls, fix production issues appropriately and provide the permanent solution for the ongoing production problems. Providing 24x7 Production support.

Environment/Software:

MS SQL Server 2000, MS SQL Server 2005, T-SQL, Windows 2003 Server, Erwin 4.5, DTS, SSIS, SQL profiler, Spotlight, Visual Source Safe 6.0, Toad v3.2 for SQL Server, XTREME Translator, SQL Compare 6.0., SQL Server 2005 Performance Dashboard, Database Engine Tuning Advisor.

Confidential

SQL Server DBA/Developer, Satyam Computer Services Ltd.,

Responsibilities:

  • Actively involved in analyzing the old database system and mapping tables, relationships, columns to SQL Server 2000.
  • Enforced the Business Rules by creating constraints.
  • Successfully managed Extraction, Transformation and Loading ETL process by pulling large volume of data from various data sources using DTS, BCP in staging database from MS Access, excel.
  • Tested to optimize the Stored Procedures and Triggers to be used in production.
  • Created Database Objects Tables, User defined functions, Cursors, Triggers, Stored Procedure, Constraints.
  • Created new cubes SSAS and Querying MDX for Quebec project.
  • Created new reports using SSRS for the project.
  • Created new SSISS packages for Quebec projet.
  • Successfully implemented indexes on tables and views for optimum performance tuning.
  • Configured replication servers and transactional replication between production and standby server for disaster recovery.
  • Developed SSIS packages, stored procedures, functions, triggers.
  • Developed, deployed and monitored DTS Packages.
  • Debugging / editing the existing SQL Scripts.
  • Optimized the performance of various SQL scripts.
  • Implemented Disaster recovery plans and backup solutions
  • Documented all process and Data Flow involved in the database for future reference.

Environment/Software:

MS SQL Server 2005, SQL Server Management Studio 2005, SQL Profiler, SSIS, SSAS, SSRS, MS Access, Query Analyzer, DTS, BCP.

Confidential

SQL Server DBA/Developer, Satyam Computer Services Ltd.,

Responsibilities:

  • Created groups, roles, users and assigning access privileges to users.
  • Designed the tables' structure and their relations using Erwin.
  • Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
  • Used DTS packages to move logins and jobs from one server to another server
  • Used log shipping for synchronizing of database
  • Tested Backup and Recovery Strategies by simulating various recovery scenarios like loss of data files, Transaction logs.
  • Resolving various performance issues and running DBCC commands, SQL Tracer, SQL Profiler and NT monitoring tools.
  • Identification of long running queries, query execution plan analysis, performance tuning and query optimization.
  • Using Data Transformation Services DTS and BCP to populate data from various data sources using the concept of OLE DB.
  • Developed SSIS packages, stored procedures, functions, triggers.
  • Exported and imported data from text files and Excel to SQL Server database using bulk copy insert and BCP utility.
  • Worked on data import and Export utility, for transferring data.
  • Environment/Software:
  • MS SQL Server 2005, T-SQL, DTS, Windows 2003 Server, SQL profiler and Visual Source Safe 6.0.

Confidential

SQL Server Developer/Analyst/Onsite Lead,

Responsibilities:

  • Handling and delivering project deliverables for a team size of 12 people.
  • executing and delivering of the work given by the client with the quality control standards as given by the client.
  • Extensively worked in the analysis phase by regularly meeting with the client in the client interaction meetings and understanding their requirements.
  • Designed and Developed database objects such as Tables, Triggers and Indexes using T-SQL.
  • Generated complex stored procedures and functions for better performance and flexibility.
  • Designed and implemented SSIS packages and Migrating DTS packages to SSIS using Package Migration Wizard.
  • Built reports and report models using SSRS to enable end user report builder usage.
  • Experienced on PL/SQL, created ad hoc requests using ORACLE database.
  • Meeting with the users on a regular basis and reviewing the current process to identify Problems/Challenges and coming up with several possible solutions.
  • Preparing the technical specification documents for the programs.
  • Check the queues MQ for messages which are failed and inform to the middleware team for resolution.
  • Coded new programs using PolicyLink and generate new reports for HLI day to day business
  • Work with the Business Analyst to understand the System Design and implement the design under the leadership of a Designer
  • Develop Component Detailed Design Specifications to describe the key logic of each component.
  • Maintain all technical documentation as required, detailed design specifications, etc.
  • Coding Using Perl, JAVA and JSP pages for Compare tool
  • Coding for ad-hoc reports, Trackers and SIR's
  • Responsible for overseeing the Quality procedures related to the project
  • Execution batches for fix and prod region.
  • Maintaining batch procedures up to date with latest changes.
  • Process development for onsite and offshore work hands-off
  • Review of deliverables from off-shore
  • Interfacing with client personnel
  • 24X7 Production and Model office support
  • Parallel Execution and meet with the other teams for preparing parallel execution.
  • Update the status to the teams as a hourly basis while running test batches and parallel execution.
  • Developed beyond compare tool, Maintaining same.

Environment/Software

SQL Server 2000, SQL Server management Studio 2005, SQL Reporting Services, SQL Server Integration services, Windows server 2003. Micro Focus COBOL, Panvalet, MF dialog, NetExpress, SQL Server 2000, JAVA, JSP, HTML, Perl, Tomcat Server, Kedit, Exceed, Oracle, Winrunner. PolicyLink, MQ series, PVCS, Tracker Merrant Windows XP, UNIX, IBM Mainframes

We'd love your feedback!