Data Entry Operator /Oracle DBA / MS SQL SERVER DBA

647-***-****

Brampton, ON

ARCHANA AWASTHI acg0xv@r.postjobfree.com

HIGHLIGHTS:

Have 4+ years experience including 2 + years’ experience as Oracle DBA, Oracle, 1.5+ years as MS SQL SERVER DBA

and 8 month of data entry and support administrator.

Done installation for 11g,10g and 9i in UNIX, AIX, HP-UX and windows environments and done couple of Oracle Database

Upgrades.

Done installation for MS SQL server 2008 and 2005.

Experienced in onsite/offshore model, worked in 7X24 support environment.

Well versed in Oracle utilities like RMAN, SQLT, Patching, Monitoring etc.

Extensive industry experience in SQL Server DBA, Configuration, Installation, Upgrading, Troubleshooting and Maintenance of

SQL server in production environment

Dedicated, hardworking and able to meet tight deadlines which stands me unique in the industry.

Good Communication skills and actively participated/scheduled meeting with onsite clients.

Comfortable to work on any Operating System like Solaris, AIX, HP-UX, LINUX, WINDOWS.

EDUCATION, TRAINING & CERTIFICATIONS

Bachelor’s Degree in Science

Bachelors of Education

Diploma in Computer Application.

Oracle DBA10g and SQL server 2008 Training, in Gwalior

WORK EXPERIENCE:

Company : e-Biz Technocrats pvt. Ltd.

Job Title : IT Consultant (Oracle DBA / MS SQL DBA)

Duration : July 2009 – Jan 2013

Company : Global ERP Solution Brampton, ON

: DATA ENTRY AND ADMINISTRATION

Job Title

Duration : Oct 2013 – Jun 2014

Company : TJX STYLE+ Brampton, ON

: DATA ENTRY AND ADMINISTRATION

Job Title

Duration : Nov 2014 – Dec 2014

PESONALITY TRAITS

Good communication skills in written and verbal both.

Ability to produce the best result in pressure situation.

Ability to work in team as well as individual.

Good Time Management Skill.

Knowledge of computer and warehouse activities

Skilled in implementing process for keeping records of incoming and outgoing goods

Excellent data-entry skills

Ability to supervise worker activities in the warehouse

TECHNICAL SKILLS

Installation / Implementation of Oracle 11g,10 and 9i on any Operating System

Good industry experience in SQL Server DBA, Configuration, Installation, Upgrading, Troubleshooting and Maintenance of SQL

server in production environment.

Creation of application databases, creation of maintenance plans and jobs, user creation and maintenance, database log space

monitoring and maintenance

Backup and Recovery using RMAN/manual

Upgrade and Migration of various Oracle database releases (11g, 10g, 9i)

Patching Application and Database

Review project requests describing database needs and work with application development and network infrastructure teams to

accomplish project.

Responsible for installation, configuration, and maintenance of MS SQL Server on various Window versions.

Monitoring MS SQL Server performance and managing the use of disk space, memory and connections

MS Excel, MS Word, MS PowerPoint, MS SQL database, Windows7

INDUSTRY EXPERIENCE:

DATA ENTRY AND ADMINISTRATION (TJX Style Brampton, ON) – NOV 2014 – DEC 2014

Environment

MS Excel, MS Word, MS PowerPoint, MS SQL database, Windows7

My Responsibilities involved

Entering purchase orders into database using Microsoft Office.

Packed and unpacked incoming and outgoing freights

Perform data entry work for stocks in the warehouse

Assembled, sorted and arranged goods utilizing maximum space

Received goods according to purchase orders

Followed the schedule for shipping goods

Identified products that are not in demand, and submitted its report to the supervisor

Monitoring and distributing incoming communications via e-mail and faxes.

Preparing business correspondence reports using Microsoft Office.

Accurate, concise and clear data entry.

Talking to customers on the phone.

Managing MS excel and preparing reports.

Develop, maintain and produce a weekly and monthly report.

Maintain customer files, updating data and document management.

DATA ENTRY AND ADMINISTRATION (Global ERP Solution Brampton, ON) – OCT 2013 – JUNE 2014

Environment

MS Excel, MS Word, MS PowerPoint, MS SQL database, Windows7

My Responsibilities involved

Entering purchase orders into database using Microsoft Office.

Monitoring and distributing incoming communications via e-mail and faxes.

Preparing business correspondence reports using Microsoft Office.

Accurate, concise and clear data entry.

Talking to customers on the phone.

Managing MS excel and preparing reports.

Develop, maintain and produce a weekly and monthly report.

Support other Administration, Sales and Service staff.

Maintain customer files, updating data and document management.

Ensure client concerns are thoroughly investigated and resolved in an efficient and professional manner

MS SQL -DBA (e- Biz Technocrates Pvt. Ltd.) – JUN 2011– JAN

2013

CLIENT: Cadbury India Ltd.

Environment

This system handles the basic material management functions like Materials planning and programming of procurement and

supplies, Purchasing, Inventory control, Storekeeping and warehousing, Materials handling and transportation, Codification and

standardization, Value Analysis, identification, Disposal of supplies, obsolete and scrap materials, Printing of various Books &

Forms, Periodicals, and Journals.

My Responsibilities involved

Installation of MS SQL server 2005 and 2008 in Windows 2000 professional.

Responsible for installation, configuration, and maintenance of MS SQL Server on various Windows versions.

Responsible for Performance and tuning of SQL servers and application issues related to migration.

Testing of applications for performance, data integrity and validation 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

Database Backup Procedures, Restoration Procedures, and Disaster Recovery procedures. Testing and implementing these

procedures

Monitoring MS SQL Server performance and managing the use of disk space, memory and connections.

Rebuilding the indexes at regular intervals for better performance.

Involved in Weekly Change Management, in which code developed by developers is being run on production server.

Supporting existing environment.

Installation of Oracle 10g and 11g database in different platforms.

Creating a database databases in different platforms (UNIX, Solaris, Linux, HP-UX, AIX, Windows).

MS SQL -DBA (e- Biz Technocrates Pvt. Ltd.) – JUL 2009– JUN 2011

CLIENT: JK TYRE Ltd.

Environment

Oracle 10g, Oracle 11g, Red Hat LINUX AS 3.0

Installation of Oracle 10g and 11g database in different platforms.

Creating a database databases in different platforms (UNIX, Solaris, Linux, HP-UX, AIX, Windows).

Monitoring Database activity using Oracle Enterprise Manager, TOAD.

Creating database users and granting required Roles.

Creating and managing Tablespaces.

Creating and managing Roles.

Patch Analysis and Implementation on Sandbox & Development Instances.

Taking Database cold backups.

Taking schemas backups using IMPDP/EXPDP utility.

Gather stats for schema and tables.

Deploying sql scripts in development and QA databases.

Generating stats pack report.

Opening service request with Oracle when required.

Adding data files in tablespaces.

Resizing datafiles when required.

Rebuilding the indexes at regular intervals for better performance.

Creating database links.

Apply database patch with Opatch.

References are available on request

Contact this candidate