Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download
University of Mumbai , India
University of New Haven , West Haven
Iowa
Health Systems, Cedar Rapids ,
IA
Download Resume Format
Maya Chhajed
Email: maya@gmail.com
Phone: 917-589-9876
PROFESSIONAL SUMMARY:
- Over
Seven years of experience in MS SQL SERVER DBA ,Database Development
And
Administration (DBA)
- Extensive
knowledge of Relational Database Management Systems.
- Extensive experience in
installation and configuration of MS SQL Server
2000, 2005 and 2008 versions.
- Good Knowledge in Installing,
Configuring and Maintaining SQL Server Active/Active & Active/Passive
Clustering
- Experience in using Data
Transformation Services (DTS) and SQL Server Integration Services (SSIS).
- Experience in Database Backup and
Recovery procedures.
- Experience in Scheduling and
creating Sql Server jobs as well troubleshooting when jobs fail.
- Experience in performance tuning,
Query Optimization, Client/Server Connectivity, Database consistency
checks using DBCC Utilities.
- Hands on experience in trouble
shooting database issues.
- Knowledge in writing and debugging
stored procedures and Triggers.
·
Experience in MS SQL Clustering, Replication
and Log Shipping.
- Experience in maintaining and supporting
different types of Replication models
like Snapshot, transactional and Merge.
- Experience in maintenance of Database
authentication modes, creation of users, configuring permissions and
assigning roles to users.
- Worked on SQL Server 2005, 2008 tools like
Management Studio, Business Intelligence management Studio,
·
Experience in SQL Server reporting Services (SSRS)
·
Experience
in working high transacted OLTP systems
- Worked closely with management,
applications development staff, and users on database solutions to
business problems.
- Experience in Code Optimization and Improving
Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and
performing other maintenance tasks.
- Experience in using Performance
Monitor/Profiler to monitor and solve performance issues like Dead Locks
and Long running queries.
- Provided after hours and 24/7 database
maintenance and support.
·
Good team player,
strong interpersonal and communication skills
TECHNICAL SKILLS:
SQL Server
Tools : Enterprise
Manager, Profiler, DTS (Import & Export),
Query Analyzer, Replication, SSMS, SSIS.
Languages : C, C++, and
T-SQL.
Operating
Systems : Windows server
2003, Windows 2000 advanced
Server/server/professional,
WindowsNT/95/98/ME/X, MS DOS
Data Bases : MS-SQL Server
6.5/7.0/2000/2005/2008
MS Access 97/2000/2003
Front End
Tools : MS FrontPage
98/2000, MS Office 97/2000/XP,
MS Outlook 97/2000.
Database
Tools/IDE : Erwin.
Reporting
Tools : MS SQL
Server Reporting Services, Microsoft Operations
Manager (MOM).
EDUCATION
Bachelor of Science in Electrical Engineering
Master of Science in Electrical Engineering
PROFESSIONAL EXPERIENCE:
Kaplan Inc, New York City, NY (June 11 –Till Date)
Sql DBA
- Installed and configured 2-node and 4-node Cluster Configuration
(Active/Active /Active/Active) in SQL Server 2008 R2, 2005.
- Maintaining design structure by directing implementation of SQL
standards and guidelines.
- Completing platform upgrades and migrations by issuing instructions;
monitoring performance; coordinating actions to maintain system currency.
- Migrated SQL Server 2000, 2005 to 2008\2008 R2
- Successfully implemented Database Mirroring in SQL Server 2005 and
2008/ R2 for high availability.
- Successfully setup and maintained Transactional Replication and
Merge Replication.
- Created and Scheduled SSIS Packages as per ETL requirements.
- Created and maintained database Maintenance Plans.
- Prepared documentation on Capacity planning of all servers and made
recommendations.
- Played a major role in Data Center Migration from Chicago to New
York
- Designed and Implemented Disaster Recovery Procedures like Log
Shipping.
- Tested and implemented Backup Strategies.
- Developed and optimized database structures, stored procedures,
dynamic management views, DDL triggers and user defined functions.
- Extensively documented all the server configurations, databases,
database objects, jobs and the changes to the database.
- Documentation and Automation of various database related procedures.
- Created Linked Servers to distribute data from one server to another
server.
- Solved issues related to Server performance and Disk space.
- Resolved issues related to query optimization, database optimization
and index tuning.
- Extensive experience in backup tools like Snap Manager for large
Data Ware House Environment
- Migrated all Jobs from SQL Server to Job Maintaining tool Tidal
- Migrated Spotlight to 2008 R2 and application to higher version
- Migrated Password Manager 2008 R2 and application to higher version
- Maintaining data integrity by establishing standards; monitoring
performance.
- Maintaining database performance by developing tuning methodologies.
- Developing and maintaining production, staging and back-up database
support documentation.
- Assisting in support for resolving system performance issues and
malfunctions.
- Experience in Code Optimization
and Improving Efficiency in databases including Re-indexing,
Creating New Statistics, Recompiling Stored Procedures and
performing other maintenance tasks.
- Experience in using Performance
Monitor/Profiler to monitor and solve performance issues like Dead Locks
and Long running queries.
- Integrating new equipment and database software as it is purchased.
- Providing development support to software engineers by developing
stored procedures as necessary.
- Providing information by collecting, analyzing, and summarizing
database performance and trends.
- Write and maintain documentation as required.
- Accomplishing department and organization mission by completing
related tasks as needed.
- Providing end-user database support.
- Providing 24x7 on call database support if required.
ENVIRONMENT: MS SQL Server 2000/2005/2008, T-SQL, Spotlight, Visio,
Snapmanger, Tidal, Windows 2003, 2008 Server
Marsh Financial Services, Minneapolis, MN (Feb10-May 11)
SQL Server DBA
·
Installed MS SQL Server,
Performed Database Design and created User Databases
·
Performed migration of all the
databases from Sql Server 2000 to Sql server 2008 along with all DTS packages to
SSIS.
·
Troubleshooting of Upgrades
issues like SQL Server 2000 to SQL Server 2008, Edition upgrades and hotfix
upgrades
·
Scheduled backups and performed
restore operations for system test data depending on developers’ requirement.
·
Created maintenance plan and
sql server jobs and scheduling them, setting emails alerts on failure.
·
Created SSIS Packages to upload
test data from Text files.
·
Managed Disk space, memory and
User connections.
·
Tuned SQL Server using DMVs,
SQL Profiler and Windows Performance Monitor.
·
Detected and
troubleshoot SQL Server related CPU, memory, I/O, disk space, and
other resource contention
·
Performed Database Integrity
Checks, updated Database Statistics and performed Re-indexing.
·
Performed query plans and made
sure each and every query is using appropriate indexes.
·
Using profiler to find badly
performing queries and deadlocks
·
Used DBCC checks and fixed data
corruption in Application databases
·
Administered MS SQL Servers by
creating User logins and assigned them proper permissions, observing all
process running on the server making sure server will run at its best.
·
Responsible for capacity
planning, monitoring Disk I/O, CPU and memory
·
Responsible for Stored
Procedures optimization, Performance tuning & index tuning.
ENVIRONMENT: MS SQL Server
2000 and 2008, Windows 2000 Advanced Server, Erwin
Pearson, Mesa, AZ
(Aug 08-Jan 10)
SQL
SERVER DBA
- Performed Database
Administration and Management activities in a safe, recoverable and
professional manner that ensures the optimal operation of all database
environments.
·
Database and Log Backups &
Restoration, Backup Strategies, Scheduling Backups. Backing up user &
system databases and restoring.
·
Used SSIS to load various txt docs
into Sql Server 2005.
·
Proper use of Views to prevent
unauthorized access.
·
Periodic checking of all
databases with DBCC commands for maintaining data consistency and integrity.
·
Created sql server backups as
part of maintenance plan and monitor them.
·
Tested backup and recovery
strategies in a test environment before and after moved to production
environment.
·
Assist with the development and
implementation of database standards and methodologies.
·
Created Linked Servers to
retrieve, Join and Combine data with local data from remote servers
·
Configured Log Shipping to
create a stand by server for production server.
·
Coordinated and performed
quality assurance testing for movement of database and objects from development
to testing and production environments.
·
Maintained and created
Transactional and Snapshot Replication.
·
Responsible for stored
procedures optimization, performance tuning and index tuning.
·
Responsible for keeping system
and databases up-to-date by making necessary changes.
ENVIRONMENT:
MS SQL Server 2005, T-SQL, SSIS, Windows 2003 Server.
Microsoft Corp, Charlotte ,
North Carolina
SQL Server Product Support Engineer/ DBA
Microsoft is an American Multinational Computer Technology
Corporation. It develops wide range of software products for computing devices.
Microsoft, Charlotte is one of the support centers that have been supporting
Microsoft’s best selling products like Microsoft Windows Operating System,
Microsoft SQL server (integrated with many services like Analysis Services,
Reporting Services, and Notification Services), .NET, VB, Share Point and many
more. This support center has several expert teams that have been supporting
customers during their typical installation and configuration issues, business
linked software solutions and server down cases. SQL Core Team and performance
team, in which I have been supporting and troubleshooting all the activities of
Microsoft SQL Server (different versions), are of them.
·
Communicate with corporate
customers via telephone, written correspondence, or electronic service
regarding problems identified in Microsoft SQL Server software
·
Expertise in all the
installation and configuration issues of Microsoft SQL Server (different
versions). Including cluster setups
·
Find out the root cause and
troubleshooting of cluster failover
·
Troubleshooting of Upgrades
issues like SQL Server 2000 to SQL Server 2005, Edition upgrades and hotfix
upgrades
·
Every type of performance
issues like server wide performance issue, database wide performance and stored
procedure tuning issues( with the help of pssdiag , readtrace utility and
performance dashboard reports)
·
Replication configurations and
troubleshooting replication issues like replication agent’s failure, and
performance issue
·
Troubleshooting issues related
to tools, Management Studio/SEM, SQL Agent – scheduled tasks, Maintenance
Plans, Import/ Export Wizard, Migration Advisor
·
Expertise in Server Management
like administration, Backup/Restore, Space Management (auto growth/shrink, file
groups), Attach/Detach
·
Troubleshoot data corruption
issue (Server down situation), understand the dbcc checkdb output, planning of
disaster recovery
·
Expertise in configuring and
maintaining log shipping, database mirroring, replication and clustering
·
Troubleshooting security and
permission related issues, all type of memory related issues (like: out of
memory error), basic connectivity issues and full text search issues.
·
Expertise in handling server
failures and analyzing stack dumps(non-yielding and exception analysis)
ENVIRONMENT:
MS SQL Server 2000/2005/2008, T-SQL,
Windows 2003 Server.
SQL Server DBA
·
Worked on the consolidation of
all database servers to a two node windows 2003 cluster.
·
This involves database upgrade of all 7.0 servers and 2000
servers to sql 2005 and moving the database to the cluster node.
·
Developing Backup & disaster recovery strategies and
implementing on all production servers.
- Installing and managing Active/Active cluster servers
on Windows 2003
- Providing support to production database.
- Creation of DTS, SSIS packages, and ActiveX Scripts to
load Data.
- Experience in writing stored procedures, triggers and
Views.
- Running DBCC
consistency checks, and fixing data corruption in application databases.
- Using profiler to find badly performing queries and
deadlocks.
- Creating and managing schema objects such as tables,
views, clustered indexes, procedures, triggers.
- Server fine-tuning & trouble
shooting. Monitoring MS SQL Server performance and network issues
- Administering the MS SQL Server by
creating user logins with appropriate roles, dropping and locking the
logins, monitoring the user accounts, creation of groups, granting the
privileges to users and groups
- Installing SQL Server service packs
based on the errors and flaws that are found in the application
- Helping QA personals in deploying and testing the
application, which uses SQL Server as a database
Environment: MS SQL
Server 2005, MS Outlook, TSQL, SQL Server Business Intelligence Development
Studio.
Thermatool Corp, East Haven , CT
SQL Server DBA
Thermatool
one of the leading manufactures for high frequency
welders, cutoffs, and heating equipment for the production of pipe and tube. Thermatool’s innovative approach to process high grade
materials applies proven designs to evolving industry needs.
RESPONSIBILITIES
·
Building Database design using
Erwin, creation of user databases, Installation of MS SQL Server & Clients
·
Database and Transaction log backups &
restoration, backup strategies, scheduling the backups. Backing up
system & user databases and restoring them whenever necessary.
·
Managing the SQL Servers in Clustered Environment.
·
Monitoring the replication
between two sites, Support and maintenance of MS SQL Server Transactional Replication
·
Migrated database, logins and
passwords from various Sql Server 2000 instances to Sql server 2005.
·
Running DBCC consistency checks and fixing data corruption in application
databases.
·
Installing SQL Server service
packs based on the errors and flaws that are found in the application
·
Using Data Transformation
Services (DTS) to populate data from various data sources
Using the concept of OLE DB
·
Implementing disaster recovery
site, procedures and testing the same for disaster recovery purposes.
- Worked
on linked servers to run distributed queries between SQL server and other
data sources using ODBC, OLE DB Drivers.
·
Server & Application
fine-tuning & trouble shooting. Monitoring MS SQL Server performance and
network issues.
·
Administering the MS SQL Server
by creating user logins with appropriate roles, dropping and locking the
logins, monitoring the user accounts, creation of groups, granting the
privileges to users and groups.
·
Assigning the users to
particular groups. Database objects ownership types.
Security and
auditing on SQL Server.
- Providing support to the Application developers on the application databases.
ENVIRONMENT: Erwin 7.1, SQL Profiler, Query
Analyzer, Enterprise Manager, SQL-Server 2000\2005, Active/Passive
cluster.
Mohanraj Trading &
Exchange Ltd, Mumbai , India
SQL Server
DBA/Developer
Mtel is
one of the leading foreign exchange
brokers in the city of Mumbai, offering private individuals and companies the
ability to achieve significantly better foreign currency exchange rates and
exceptional service.
RESPONSIBILITIES:
- Involved in
installation and configuration of SQL server 2000 on Servers.
- Applied patches
and service packs to keep the database at current patch level.
- Created
Database Objects like Tables, Stored Procedures, Views, Triggers, Rules,
Defaults, user defined data types and functions.
- Implemented
database standards and naming convention for the database objects.
- Implement and maintain database
security.
- Implemented trigger and stored
procedures and enforced business rules via checks and constraints.
- Fine tuned Stored Procedures using Execution Plan in T-SQL for
better performance.
- Going through the clients' requirements
and coming up with database design and application architecture.
- Troubleshoot and minimize production
down issues.
- Designed new job process, new database
maintenance plans, DTS programs and did performance tuning of the existing
processes.
- Created Scheduled maintenances and backup procedures to the
database as a disaster recovery method.
- Data conversions and data loads from
various databases and file structures.
- Monitor failed and long running MS SQL
Server jobs.
- Monitor, tune, and analyze database performance and allocate server
resources to achieve optimum database performance.
- Maintaining User account administration for Different domains.
ENVIRONMENT: SQL-Server, DTS, T-SQL,
Download Resume Format
.JPG)
0 comments:
Post a Comment