Data Entry Operator /Oracle DBA / MS SQL SERVER DBA
Brampton, ON
ARCHANA AWASTHI **********@*****.***
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