Sql Developer Resume Profile
Professional Summary:
- IT Professional with 8 years of Administration and Development experience on Data Design using SQL Server 2008R2/2008/2005/2000 systems in OLTP and OLAP environments.
- Expertise in installing MS SQL Server 2012, 2008R2, 2008, 2005, 2000 and associated database tools, updating with latest service packs, hot fixes and security patches.
- Implemented managed Active-Active and Active-Passive Clustering, Failover and Load Balance technologies.
- Implemented Side-by-Side Migration of MS SQL SERVER 2000/2005 to 2008.
- Proficient in SQL Server 2008 new features like Merge Statement, Filtered Indexes, Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption TDE , Backup compression, Lock escalation and new data types.
- Implemented the new SQL Server 2005 concepts like Data partitioning, Snapshot Isolation, Database Mirroring, Database Snapshot, DDL triggers, Try-Catch blocks, Online Indexing, Online Restoring, DMV's, DMF's, Mail Setup, Jobs and Alerts, Database Tuning Advisor.
- Dexterity in implementing different types of High Availability Disaster Recovery scenarios like Clustering, Database Mirroring, Transactional Replication and Log Shipping.
- Configured more than 2GB RAM in 32 bit environment using AWE and /3GB switch.
- Expertise in Performance Tuning, Index Tuning Wizard, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
- Data modeling Experience including Physical and logical data modeling using ERWIN VISIO.
- Experience in implementing various RAID 1, 5 and 10 technologies.
- Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling Backup/Recovery of databases, Replication, Linked Servers, Database Maintenance Planning.
- Expert in using Native tools like SQL Server Profiler, Database Tuning Advisor and Perfmon.
- Expertise in resolving locks deadlocks, handling Isolation level and concurrency effects, detect CPU, I/O, Memory bottlenecks.
- Sound knowledge in writing complex SQL Queries, stored procedures, Normalization, creating Indexes, Indexed views, file group modifications, User Defined Functions UDF , Triggers, Distributed Queries, Common Table Expressions and adding scheduled jobs to re-index and update statistics in databases.
- Expertise in reading and understanding execution plan and fixing query to execute with low cost using various operators depending on the scenario.
- Acquaintance in supporting Very Large databases VLDB 2TB and troubleshooting the problems in OLTP Environment.
- Extensively used repositories like Team Foundation Server TFS , Visual source safe and Clear case for Data Archival.
- Expertise in extracting and transforming data using data transformation services like import/ export wizard, BCP, Bulk insert, attach/detach.
- Prowess in planning and implementing Database Security by creating Logins, Users, Roles and assigning permissions to them.
- Experience in developing and tuning SQL Server Integration Services SSIS packages and Reporting Services SSRS reports.
- Experience in creating deployment utility to Deploy SSIS Packages over Production and QA Systems.
- Good experience in configuring IIS and XML.
- 24 X 7 Production Database on Call Support.
- Experience in Creating Report Subscription, Data Driven Subscription, Report Snapshots and caching, linked, cascaded and parameterized reports, complex drill down reports using SQL Server reporting services.
- Configuring and maintaining Report Manager and Report Server. Good understanding with SQL based reporting tools like Crystal Reports.
- Created Linked Servers between SQL Server Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.
- Handled numerous Change Management requests on production servers.
- Flexible, Enthusiastic and project oriented team player with excellent communication skills and analytical skills to develop creative solution for challenging client needs.
Application Experience in:
- Administration and Installing of MS SQL Server 2012, 2008 R2, 2008, 2005, 2000, 7.0.
- Database Designing and Security.
- Setting up Active/Passive, Active/Active clustering with multi node environment.
- Setting up Replication, Log Shipping, Data Mirroring using MS SQL Server 2008, 2005.
- DTS Data transformation services and SSIS SQL Server Integration Services .
- Experience with writing SQL Scripts and batch files.
- Good hands on experience with T-SQL.
Technical Skills:
Operating Systems | Windows Server 2012, 2008R2, 2008, 2003, 2000, Windows XP Professional, Vista and Windows 7 |
Databases | MS SQL Server 2008/2005/2000/7.0, MYSQL, Oracle, MS Office Access 97/2000/2003. |
ETL TOOLS | SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , SQL Server Analysis Services SSAS , Data Integrator, Data transformation services DTS |
Data Modeling Tools | Erwin, Red gate, Litespeed. |
Languages | T-SQL, C/C , C , javascript, Visual Studio2005/2003, ASP.NET, VB.NET |
Applications | Microsoft Office, Adobe Photoshop and Flash. |
Professional Experience:
Confidential
SQL Server DBA - Development/Production Support
Responsibilities
- Maintaining the database consistency with DBCC at regular intervals
- Identify and resolve database performance issues, database capacity issues.
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users
- Used SQL IDERA diagnostic manager to monitor, diagnose and resolve issues database performance issues for highly mission critical SQL instances
- Worked on Microsoft Active Directory Services
- Monitored and modified Performance using execution plans and building the indexes using the Database engine tuning advisor DTA
- Migrated MS SQL Server 2008 R2 databases in VMware environment
- Installed and configured MS SQL Server 2012.
- Worked on the TEMPDB performance issues, monitored and troubleshooted the TEMPDB database on a regular basis.
- Worked extensively with SQL profiler for tuning queries using variable for characteristics and query costs.
- Fine tuned the stored procedures and views by recommending to the development teams to use the NOLOCK after every table, to use the MERGE statement instead of insert, update and delete statements.
- Implemented managed 3 node Active-Active-Passive clustering, failover and load balance technologies as per client requirement.
- Maintained the High Availability solution Mirroring as a database disaster recovery technique and Rebuilding the indexes once in every 2 days on the principal database for better performance by monitoring the transaction logs carefully
- Efficiently implemented the daily and the hourly snapshots Read only of the principal database on the training/development instance
- Trouble shooting the Clustered instances due to the cluster service failover and network inconsistency issues.
- Experience in index tuning and performance optimization techniques
- Monitored and modified Performance using execution plans and client statistics
- Operational support for SQL Server Report services SSRS by creating the data sources for the appropriate databases
- Designed the databases for the reporting functionality of the reporting team
- Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
- Worked extensively on the SCOM tool to actively read the alerts from the SQL instances and the windows servers
Environment: SQL Server 2008 R2 with clustering 64/32 bit , T-SQL, SQL IDERA diagnostic manager, Windows 2003/2008 x86/x64 , SSRS, VSS, Visio, DTSRUN, Power shell, Microsoft Active Directory Services, BCP, AJAX, Visual Studio, VERITAS Netback up, Net App Storage, SCOM, ER Studio, MS Cluster Service MSCS , XML Comm Vault, SQL Sentry, Perfmon.
Confidential
Senior SQL Server DBA
Responsibilities:
- Administrated and Managed SQL Server 2008R2/2008/2005/2000 databases in Production, Staging, QA and development environments.
- Responsibilities include the Production and Application Support for the Database and Application Servers.
- Upgraded/Migrated SQL Server 2000 databases to SQL Server 2008R2/2008/2005 databases and mentored other technical staff.
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Resolving performance issues using DMVs Dynamic Management Views .
- Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
- Installing, Configuring and Maintaining SQL Server 2008R2/2008/2005 64 bit on Active/Active Cluster with latest Service Packs, Hot Fixes.
- Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
- Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.
- Designed the Database Recovery plan and implemented the Database Mirroring in SQL Server 2008/2005 and participated in Disaster Recovery Drill processes.
- Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.
- Implemented new features in SQL Server 2008 like Policy based Management, Table Compression, Backup Compression, SQL Server Auditing, Resource Governor and Merge statement in T-SQL.
- Performed data partitioning for efficient management of database tables and indexes.
- Extensively working on performance issues like update statistics, Auto Stats.
- Involved in Change Data Capture process.
- Maintained Production and Test Database Environment in SQL server 2008R2/2008/2005.
- Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.
- Designed and developed SSIS packages using different control flow tasks, data flow task and data transformations.
- Debugged and Deployed SSIS packages in to file system server and MS SQL Server with the help of manifest file.
- Designed, Developed, Configured and Deployed custom build business reports using MS Reporting Services - SSRS.
- Provided 24/7 Support for Production , Development Test Servers of MS SQL Servers
Environment: MS SQL Server 2005/2008/2008R2/2012, Windows 2008 server NT, IIS Server 6.0, SSIS, Reporting Services.
Confidential
Ms SQL Server DBA
Responsibilities:
- Create and maintain various databases for Production, Development and Testing Servers using MS SQL Server 2005. Planning the location of data, indexes, and Transaction log files on the disk.
- Install and configure SQL Server 2005 on the server and client machines, provide connections and manage databases.
- Use of DBCC Utilities to maintain the consistency and integrity of each database in the production server.
- Conducted root cause analysis of application availability and narrow down the issues related to coding practices, database bottlenecks, or network latency.
- Resolve locking and blocking issues.
- Configured up to 32 GB of memory.
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Tuning the Production server to get the performance improvement.
- Running Index Tuning wizard for optimal query performance.
- Implemented Database Mirroring as part of disaster recovery plan.
- Implementing and Monitoring Transactional Replication and other SQL Server jobs using custom scripts.
- Reviewed third party tools to automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs.
- Monitoring SQL Server LOGS, Application logs and analyzing the logs.
- Maintaining both DEV and PRODUCTION Servers in sync.
- Creating Backup strategies and scheduling them as a part of database maintenance plans.
- Created the SSIS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
- Involved in Performance Tuning for source databases, target databases
Environment: MS SQL Server 2005, Windows 2000 Advanced server NT, IIS Server 5.0, SSIS, Reporting Services, XML.
Confidential
MS SQL Server Developer/DBA
Responsibilities:
- Designed and implemented multiple systems using MS SQL Server 2000.
- Prepared Estimates for Database, table size growth.
- Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
- Monitor connections, locks and performance of SQL server.
- Configured Log shipping of production servers and created the DR servers.
- Implemented and configured Transactional and Snapshot replication.
- Assign permissions to users and roles. Support column level permission. Administer secure authenticated logins including both Windows and SQL Server Accounts.
- Responsible for MS SQL Server 2000 configuration, tuning and provide 24X7 dedicated support to all Production, development and cluster servers.
- Performed all aspects of database administration, including backups and recovery.
- Created documentation to install SQL Server, apply service pack, hot fix and clustering installation.
- Additionally, designed and implemented a disaster recovery system.
- Installed and configured Microsoft SQL 2 node Clustering Active/Passive .
- Creating Logins and Roles with appropriate permissions.
- Involved in the logical and physical data modeling using Erwin tool.
- Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
- Create and manage OLAP Cubes on analysis servers and query cubes using MDX queries.
- Develop and manage DTS Packages and scheduled jobs for periodic and nightly batch processes.
- Expertise in Security Issues such as creation and granting permissions on various Objects.
- Preparing the reports for the day-to-day as well as weekly/monthly purposes.
Environment: MS SQL-Server 2000, DTS, SQL Diagrams, Erwin, Windows 2000 Server, MS Access, MS Excel, MS Analysis Services, MS Reporting Services, HTML 4.0.
Confidential
SQL Developer
Responsibilities:
- Sound knowledge Stored Procedures, Indexed views, User Defined Functions UDL , Triggers Distributed Queries and Common Table Expressions.
- Understanding the environment and tables and business logic.
- Understanding the user requirements and creating the logics and scripts
- Implementing the database objects like stored procedures, Functions and Triggers.
- Debugging and fixing the bugs.
- Worked to create Software Requirement Specification SRS document.
- Developed and coded applications in T-SQL.
- Designing the Logical and Physical databases and development of SQL Server Database.
- Created the DTS packages to load the data file excel files into SQL table.
- Designing the scenarios and process flow using UML.
- Preparation of Entity Relationship diagrams and data flow diagrams.
Environment: TSQL, MS SQL SERVER 2000, ENTERPRISE MANAGER, VB.NET, WINDOWS SERVER 2003.