CONSULTANT NAME
(SQL DBA)
SUMMARY
| Over Six years of IT experience in SQL Database Administration, System Analysis, Design, Development & Support of MS SQL Servers 2005, 2000 and 7.0 in Production, QA, Reporting Services, Development environments & Replication and Cluster Server Environments.
|
| Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2005/2000.
|
| Experience in upgrading SQL Server from version 2000 to 2005.
|
| Have good experience with partitioned schemas, partitioned tables and indexes, creating Filegroups using SQL Server 20005.
|
| Good experience with SQL Server 2005 online Indexing and Recoveries features.
|
| Good experience with implementing DR solution, High Availability of database servers using Database mirroring and replications and Log Shipping.
|
| Experience in Data Migration Management.
|
| Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.
|
| Created maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics.
|
| Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS Packages.
|
| Extensive experience in writing Distributed Queries between SQL Servers by creating link servers and federated servers.
|
| Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
|
| Experience in performing integrity checks. Methods include configuring the database maintenance plan wizard and DBCC utilities.
|
| Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
|
| Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
|
| Experience in applying patches and service packs to keep the database at current patch level.
|
| Experience in migrating packages from DTS to SSIS.
|
| Good experience with Analysis Services, Reporting Services, and SQL Server Clustering. |
| TECHNICAL SKILLS |
| Operating Systems: | Windows 2000/2003 Server, Windows 95/98/XP/NT |
| Databases: | MS SQL Server 7.0/2000/2005, Oracle8/9i |
| Languages: | T-SQL, PL/SQL, C, C++, and Core Java JDK 1.1 |
| SQL Server Tools: | Management Studio, Business Intelligence Development Studio, Visual Studio 2005, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, OSQL, DTS, Log Shipping, Server Network Utility, Database Tuning Wizard, Index Tuning Wizard, SSIS, SSAS, SSRS, Microsoft Clustering Services (MSCS) |
| Report Tools: | MS Reporting Services, SAS |
| Data Migration: | MSDTS, SSIS, BCP, Data Migration, SQL Loader, Import/Export Wizard |
| Database Modeling & Other Tools: | ERWIN 4.x, Quest Litespeed, Quest SQL Spotlight, Redgate SQL Compare, SQL Trace |
PROFESSIONAL EXPERIENCE
| Client Name |
From Date - To Date |
| SQL Server DBA | |
Responsibilities:
| Responsible for Database support, troubleshooting, planning and migration. Resource planning and coordination for application migrations with project managers, application and web app teams. Project involved guidance and adherence to standardized procedures for planned data center consolidation for worldwide centers using in-house corporate and third party applications based on SQL 2000 in upgrade project to SQL 2005.
|
| Monitoring of database size and disk space in Production, Staging & Development environments
|
| Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration. Security and architectural planning issues met as well as testing and training.
|
| Performed installation of SQL Enterprise 2005 64bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers. Patch applications.
|
| Failover cluster testing and resolution on HP servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
|
| Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.
|
| Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
|
| Configured Database mail, linked servers in SQL server 2005.
|
| Creation and scheduling of Maintenance plans (database and log backups and cleanups), DTS to SISS package conversions. Business Intelligence package design. Created tables and performed data imports and restores for successful migration. Scripting development and troubleshooting for various security syncing scripts to new databases as well as creation of database roles for granting Stored Procedure rights.
|
| Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS packages.
|
| Good Knowledge of using SSRS (SQL Server Reporting Services).
|
| Installed and configured SQL Server Cluster server in SQL Server 2005 using HP servers for HP Customers.
|
| Performed Production support and on Call duties.
|
| Executed Change management scripts on weekly basis.
|
| Documented upgradation procedures from MySQL to SQL Server and Oracle to SQL Server.
|
| Created monitoring scripts to alert for production issues.
|
| Migrated Databases from MySQL, Oracle, IBM Informix, to SQL Server 2005. |
Environment: SQL Server 2000, SQL Server 2005, HP Data Protector, Windows 2000/2003 Servers, T-SQL, Oracle PL/SQL, MySQL, Oracle 9i, PL/SQL Developer Tool, Informix 7.
| Client Name |
From Date - To Date |
| SQL Server DBA | |
Responsibilities:
| Performed server installation and configurations for SQL Server 2005 and SQL Server 2000.
|
| Performed installation of SQL Server Service Packs.
|
| Upgraded databases from SQL Server 2000 to SQL Server 2005.
|
| Involved in capacity planning, sizing and database growth projections.
|
| Scheduled Full and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard.
|
| Setup backup and restoration jobs for development and QA environments
|
| Created transactional replication for the reporting applications.
|
| Implemented disaster recovery solution at the remote site for the production databases using Log Shipping.
|
| Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.
|
| Used System monitor to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database server performance.
|
| Used SQL Server Profiler to monitor and record database activities of particular users and applications.
|
| Used DBCC commands to troubleshoot issues related to database consistency.
|
| Used Index tuning wizard to redesign and created the indexes for better performance.
|
| Fine tuned Stored Procedures using Execution Plan in T-SQL for better performance.
|
| Streamlined the server/database level security by creating the Windows and SQL logins with the appropriate server/db roles and object level permissions.
|
| Used Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
|
| Worked on upgrading DTS packages to SSIS packages.
|
| Implemented trigger and stored procedures and enforced business rules via checks and constraints.
|
| Worked with various business groups while developing their applications, assisting in database design, installing SQL Server clients, phasing from development to QA and to Production environment.
|
| Reviewed DB Scripts from the development team before releasing them into the Production. |
Environment: Windows 2003 Server, SQL Server 2005, SQL Server 2000,T-SQL, PL/SQL, Erwin 4.1, JavaScript, MS IIS Server 5.0, SOAP, HTML/DHTML, XML, Oracle8i.
| Client Name |
From Date - To Date |
| SQL Server DBA | |
Responsibilities:
| Management of SQL Servers, databases, storage management for databases sizing from 25GB to 40GB.
|
| Responsible for General Database Administration and Performance.
|
| Data Migration from legacy to master tables using DTS-import and Export wizard.
|
| Trouble shooting Problems by using SQL server profiler.
|
| Updating with latest service packs and security patches.
|
| Created views to facilitate easy user interface implementation, and triggers to enforce Data and referential integrity.
|
| Created indexed views in T-SQL to increase the query performance.
|
| Develop Backup & Restore scripts for SQL Server as needed.
|
| Created reports using SQL Server Reporting services.
|
| Has done DBCC checks to ensure the physical consistency of the database and objects.
|
| Checking Space monitoring, Index Defrag, Update Statistics, Log Shipping between Primary production servers and Standby. |
Environment: Windows 2000 server, VB6.0, XML, SQL Server 2000, Erwin 4.0, T-SQL, SQL Server Reporting services.
| Client Name |
From Date - To Date |
| SQL Server DBA | |
Responsibilities:
| Creating and maintaining various databases for Production, Development and Testing using SQL Server 2000.
|
| Installing SQL Server 2000 on the server and client machines, providing connections and managing databases.
|
| Planning and scheduling backups and developing recovery procedures.
|
| Migration of data across different databases and different servers.
|
| Creating procedures, functions, and triggers, handling database performance and tuning.
|
| SQL Server Installation, patch application, migration of databases.
|
| Creation of new databases, planning the location of data, index, and Transaction log files on disks.
|
| Setting up backups for the databases.
|
| Providing support to the Application developers on the application databases.
|
| Handled 24/7 Production Issues.
|
Environment: MS SQL Server 2000, Windows 2000 Advance Server, MS Office.
| Client Name |
From Date - To Date |
| SQL Server DBA/Developer | |
Responsibilities:
| Installation, configuration and maintenance of the MS SQL Server 2000.
|
| Migration of SQL server 6.5 to 7 and from SQL server 7 to 2000.
|
| Performance and tuning of SQL servers and application issues related to migration.
|
| Testing of applications for performance, data integrity and validation issues.
|
| Data Transfers between various servers using BCP and Managing Disk space on NT systems.
|
| Migrated oracle8i data into SQL Server 2000.
|
| Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
|
| Complete automating on NT so that the tasks are run with out user monitoring.
|
| Writing the stored procedures, checking the code for efficiency. Routine backups and restoration.
|
| Administrative and Production support for various applications in all environments.
|
| Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans. Testing and implementing these procedures. |
Environment: SQL Server 2000, SQL server 7, SQL server 6.5, T-SQL, Oracle PL/SQL, Query Analyzer, SQL Profiler, Windows 2000 Server, Import & Export Data, Oracle8i, TOAD.
EDUCATION/CERTIFICATIONS
Bachelor of Science in Computer Science from Bharathi Dasan University, India - 2002
Pursuing Microsoft Certification MCPD.
PLEASE LEAVE YOUR COMMENTS BELOW
|