DBA /DB Developer

Permanent Address:

Address: ****, **. *****,

Pierrefonds,

Montreal- H8Y3P3

Email: **********@*****.***

Contact No.: 514-***-****

Smita Varma

Objective:

Work efficiently in the areas of Database Administration/Development (Oracle 9i/10g and SQL server 2000/2005) in an organization where there is a possibility of growth.

Seek challenging projects in a progressive career path with a company that enforces a professional environment, where I can utilize my analytical and technical skills in conjunction with the company’s goals and objectives.

Academic Qualification:

MIT: Master in Information Technology from MAHE University, Manipal, Karnataka, India.

ACSE: Advanced Certificate in Software Engineering from IBM - ACE, Bhopal, M.P., India.

B.Sc. (Medical) Bachelor in Science (Medical Group), M.D.S. University, Ajmer, Raj., India

Technical Skills:

Area of Specialization: SQL Server 2000-2005 DB Administration, Oracle 7/8/8i/9i/10g DBA, Redhat Linux Administration.

Website designing & Development, Programming Logic & Concepts with various programming

languages, Trouble shooting and debugging.

Training:

OCA (Developer’s Track): Oracle 9i Certification from SQL* International, Pune, India.

Passed SQL Fundamentals (IZO - 007) exam for OCA (Oracle Certified Associate), preparing For PL/SQL (IZO - 147) and Database Fundamentals (IZO - 041)

RHCE: Red Hat Certified Engineer Training course from Linux Solution, Bhopal since 2005 live training on Linux Administration with Servers. Preparing for RHCE (Redhat Certified Engineering).

Work Experience:

1. Icongo.com, Montreal – (MSSQL Server 2000/2005 & Oracle DBA) June 2010 – Currently Working

Job profile: Currently Working on SQL Server 2000/2005 and Oracle 10g Administration and development.

• SQL Server 2005 T-SQL Development and DB Administration.

• Oracle 10g PL/SQL Development and DB Administration.

• Performance Tuning & Query optimization.

• Backup/Restore & Re-indexing job scheduling.

• Client’s system integration.

• Client Support and troubleshooting.

1. Mate1.com, Montreal – (MySQL DBA/Developer) Jan 2010 – June 2010

Job profile: 6 months contract. MySQL DBA on Linux systems (Ubuntu)

• Working on Extract,Transform and Load (ETL) tool to feed data for Business Intelligence (BI) and Trend Analysis.

• Backup/Restore, Query optimization, DB replication, Maatkit.

• Building Perl Scripts (DBI) to bring data from disparate data sources to one reporting server.

• Crontab Job Scheduling.

• Administering QA Databases.

2. Ecom Access., Montreal – (MSSQL Server 2005/2008 DBA/Developer) Jan 2008 – Jan 2010

Job profile: DBA/Developer (SQL server 2000 and 2005).

Managing MS SQL Server 2000 with 40 clients’ databases and MS SQL 2005 Server with 5 clients’ Databases.

• Database Developer/DBA in the Head office.

• Managing 2 Production servers (2000 & 2005), around 95 clients’ databases.

• Managing Data consistency.

• MS SQL 2000 and 2005 Server Management and Performance Tuning.

• Indexing / Reindexing and query Optimization.

• Migrating SQL Server 2000 to 2005.

• Creating failover clusters/Log Shipping/ Concept of Db Replication.

• Disk Space management.

• Backup/Restore, File Import/Export (ETL).

3. Altomar Maritime Inc., Montreal – (Webmaster) Nov 2006 - May 2007

Job profile: I was the only IT employee in the office with two major Projects to accomplish in 6 months contract which was successfully completed on time.

• Website Designing and Development

• Managing Database (MS SQL Server 2000).

• Only IT employee (Webmaster) in the company.

• Developed www.altomar.com.

• Worked on Re-designing & Development of www.shipbrokering.com.

4. Surya Concepts Ltd., Bhopal - (Asst. EDP Manager) Dec 2004 - Dec 2005

Job Profile: Position of “Assistant E.D.P. (Electronic Data Processing) Manager” at Surya Concepts Ltd., Bhopal, and M.P., INDIA

• SQL server 2000 Database Administration.

• Website Designing and Development. (www.theprimecard.com)

• Managed a team of 4 people, conducted meetings, assigning tasks, tracking Development progress.

• Reporting to EDP Manager. Meeting Deadlines.

• Technical & Administrative support.

• Software Debugging.

5. Convergys India Services Ltd., Gurgaon - (Tech. Support Officer) Dec 2003 - August 2004

Job Profile: Position of “Tech Support Officer” for SBC (Southwest Bell Corporation) Internet Services in USA. Head Office in Texas.

• Tier 1 Tech support for SBC Internet Services in US.

• Helping US Customers Troubleshoot their Internet connection problems.

• Help checking DSL Broadband connections during server outages.

6. Tata InfoTech - (Faculty & Software developer) Feb 2003 - Oct 2003

Job Profile: Worked as a “Faculty and a Software Developer”, Worked on Project (Library Management).

• Oracle 9i (OCA) Certification (IZO 007 and IZO 041 exams) coaching College and school Students.

• Taught 3-5 classes per day.

• Taught Visual basic, C and C++ and Oracle 9i OCA Certification exams.

7 During my time of learning I was also an Instructor in two places teaching RDBMS concepts

and SQL/PLSQL to school and college students.

Programming and Development Skill:

1 Front-end Designing - Microsoft Visual Basic 6, Developer 2K.

2 Languages - C, C++.

3 RDBMS - SQL Server 2000/2005, ORACLE.

4 Theoretical Concepts - Win32 Programming, OS, COM/DCOM, System Analysis & Designing Technique.

Others:

1 Applications - MS Office, Macromedia Firework, Adobe Photoshop, Swish-Mx, Flash5.

(Able to work on any software application after a short effort).

2 Internet - HTML, ASP, Java Script, VB Script, PWS, IIS.

3 Hardware/ networking - Setup/Installation, Troubleshooting & maintenance

Windows Skills:

Operating Systems: (Installation operations and administrative works supporting User and Server Security management)

1 Desktop Operating System - Dos, Windows 9x.

2 Multi-user Operating System - Windows XP, 2000 , 2003 and 2008 (professional and Advance Server).

Linux Skills: (Administration)

1 Installation, X -Windows Setup and operation with most Linux Versions.

2 User and File system administration, Quota Management.

3 RPM installation/upgrades and configuration.

4 Administration Tools, Disk Configuration, Device Management & Disk Management

5 Mounting/Un-mounting File system, Backup & Restore.

6 Servers Installation/ configuration, maintenance & troubleshooting

Mail server - Sendmail

Authentication server - NIS, Samba

Web Server - Apache

Network Server - DHCP, FTP, NFS, BIND/DNS.

Proxy Server - Squid

Web Based Configuration Tool - Samba-Swat (GUI tool).

Remote Administration - RAS, SSH, Telnet.

7 Multiple server synchronization.

8 Firewall Security - IPTables, IPChains, SELinux.

9 RAID Levels & Quota.

10 Bridging between two Networks using virtual LAN Card.

Extracurricular Activities:

5 Active User in various SQL server, Oracle & Linux discussion group and Forums worldwide.

6 Active User of various Programming and debugging discussion group and Forums worldwide.

Strengths:

I have good debugging and programming skills with Logical Reasoning. I am a good team worker. I am punctual and hardworking and a fast learner. People find me trustworthy. On the job, learning is my forte.

Contact this candidate