SUMMARY:

• Looking for a challenging and fast paced job/position as a Database Administrator in a professional growth - oriented firm where I can use, apply, expand and build on my professional expertise, skills and .
• 6 years professional DBA experience
• 6 years SQL Server DBA experience (2000,2005,2008)
• 4 Integration Services, Reporting Services, and Analysis Sevices
• 6 years Oracle (have used 8,9, 10g, 11g,)
• 5 years MySQL
• Experience tuning, backup and recovery, a little with patching, TSQL and PLSQL
• Experience setting up stored procedures, packages and triggers, replication, configured SQL Server 2005, set tables, integrated SQL, etc.
• Adept at Crystal Reports 1 year

TECHNICAL SKILLS:

Systems: Windows (2003/2000/NT/XP/Vista), Linux, UNIX, Novell 5.1

Hardware: Servers, Hubs, Routers, Switches, PCs

Software: MS Office Suite, MS SQL Server 2000/2005,MySQL(4,5), Oracle (8i/9i/10g), Sharepoint services 20/3.0 and MOSS Server 2007, MS Biztalk server 2004/2006, Crystal Reports XI, MYSQL

Networking: TCP/IP, LAN/WAN, Ethernet, Token Ring

Languages: C#, HTML, XML, PHP, Apache, JavaScript, T-SQL, SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server/MySQL Database Administrator

Responsibilities:

• Maintain and support SQL Server database instances and applications in a high-transaction environment.
• Provide support services to end users, developers, DBA associates and Application DBAs.
• Troubleshoot, resolve, and document production problems.
• Maintain sound backup policies and procedures.
• Install, configure, and upgrade database software and related products.
• Perform routing and customary operational activities to ensure a stable database environment.
• Archive data from primary databases to archive locations.
• Perform database refreshes to non-production databases.
• Monitor vendor releases and schedule necessary patches.
• Interact with system administrators, application developers, and business process leaders.
• Contribute ideas and suggestions to improve technology solutions
• Experience in code migration and ITIL best Practice, database change, incident, Problem management and data management through the various stages of the development life cycle required.
• Install, manage, troubleshoot SQL server clusters and setup, monitor and troubleshoot Log shipping.
• Perform 24 x 7 support and participate in a weekly oncall rotation to ensure excellent service to our company and all our clients.
• Designed, architect, and build MySQL databases after determining business requirements in order to create logical models, building physical models, and plan system architecture. Experienced in designing, implementing, and managing MySQL database for high-traffic transactional systems.
• Performed MySQL installations on both windows and Linux/Unix based systems.
• Migrated/upgraded databases and applied MySQL patches.
• Supported MySQL in a 24x7 high volume production OLTP databases including development and quality Environments.
• Extensive knowledge of MySQL internals, replication and clustering including their setup, day to day management, monitoring and maintenance. etc.
• Configured and managed replication/standby instances of MySQL in local and remote data centers.
• Responsible for writing database-monitoring scripts, coming with best practices
• Used proactive approach to identify and improve databases performance.
• Used Several tools for day to day management of MySQL: Navicat for MySQL, MySQL Workbench, MySQL administrator, PhpMyadmin.

Confidential

SQL Server/Oracle Support Specialist

Responsibilities:

• IT Specialists responsible for supporting SQL Server environments and ensuring high availability, performance, and security for the environment.
• Work cooperatively with IT Specialists in other job roles to ensure that hardware resources are operating to high resilience and top performance.
• Pro-actively monitor the database infrastructure to ensure secure services with minimum downtime.
• Perform troubleshooting and problem solving of the SQL Server environment.
• Perform implementations, patching, and release of database changes while following strict change control standards.
• Provide In depth SQL Server Database Administration experience in supporting and managing multiple MS SQL 2000, 2005 and 2008 RDBMS on large systems, clusters, and various storage mediums (SAN, disk array, local) as needed.
• Demonstrate Strong self-sufficiency and initiative working on database projects.
• Managed DTS stored procedures and data replication.
• Managing the internal and external MS SQL database security.
• As Oracle DBA provides physical database support in a multi-customer environment
• Provide support of daily database administration activities ranging from simple to complex in unix and AIX,
• Scripting, installing and upgrading oracle 9i, 10G and 11g.
• Worked with OEM Grid and RAC .
• Work in multiple backup and recovery scenario environment using (i.e TSM, SQL Backtrack etc) and including deep understanding of RMAN backup and recovery, incremental and cumulative backups, various recovery scenarios, and archive management.
• Operation and maintenance of Oracle database management software running on distributed platforms, using high availability solutions and load balancing.
• Wrote Documentation to Help with daily task and routines.
• Help in and mentoring Junior DBA staff.

Confidential

Oracle/MySQL Database Administrator

Responsibilities:

• Reviewed and maintained data models describing data elements and how they are used, following procedures and using pen, template or computer software.
• Established and calculated optimum values for database parameters, using manuals and calculator.
• Modified existing databases and database management systems as required.
• Planned, coordinated and implemented security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
• Reviewed procedures in database management system manuals for making changes to database.
• Reviewed project requests describing database user needs to estimate time and cost required to accomplish project.
• Reviewed workflow charts developed by programmer analyst to understand tasks computer will perform, such as updating records.
• Selected and entered codes to monitor database performance and to create production database.
• Specified users and user access levels for each segment of database.
• Tested programs or databases, corrected errors and made necessary modifications.
• Wrote and coded logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.
• Approved, scheduled, planned, and supervised the installation and testing of new products and improvements to computer systems, such as the installation of new databases.
• Developed methods for integrating different products so they work properly together, such as customizing commercial databases to fit specific needs.
• Identified and evaluated industry trends in database systems to serve as a source of information and advice for upper management.
• Revised company definition of data as defined in data dictionary.
• Trained users and answer questions.
• Worked as part of a project team to coordinate database development and determine project scope and limitations.
• Installation, configuration and administration of MySQL RDBMS software.
• Managed backup and recovery processes including replication for failover environments as well as disaster recovery.
• Supported multiple system environments for development, testing and production application releases.
• Performed logical design and physical implementation of data services layer.
• Monitored, diagnosed, and resolved database performance issues proactively.
• Identified and implemented processes and infrastructure improvements in various database aspects.
• Controlled and monitored user access to databases and maintain database security.
• Participated in an on-call rotation with other operations DBA's.
• Automated routine tasks through scripting and tools.
• Interfaced with development and operations teams for database requirements.

Confidential

Data Communications Analyst

Responsibilities:

• Installed SQL Server 2005 and performed upgrade of several SQL Server 2000 instances of the Database Engine to SQL Server 2005 using the SQL Server Installation Wizard to complete this task.
• Used Management Studio, T-SQL to create databases. I added data files to the database, setting the databases at times to Single Restrict Access .I was also required to create logins, users, and schemas in SQL Server 2005.
• Configure the properties of new linked servers and an OLE DB provider using Microsoft's SQL Server 2005, specifically within SQL Server Management Studio. Configured the linked server's general properties, security model, server options and ultimately the OLE DB provider.
• Created tables, adding constraints, and altering the tables. Created database views based on existing tables.Created online indexes which were mostly non-clustered indexes.
• Created and implemented stored procedures by creating, modifying, recompiling, viewing and deleting the stored procedures.
• Creating Queries Using T-SQL, used queries to retrieve and modify data in a SQL Server.
• Worked with XML data in SQL Server 2005 by retrieving XML data from a table, inserting XML data into a table, setting XML documents to use the xml type and creating an HTTP endpoint. Also work with transactions using various statements; beginning transactions, setting savepoints, rolling back transactions ending transactions.
• Performed import and export of bulk data in SQL Server 2005.
• Perform management and monitoring tasks using the SQL Server Agent service which involved creating jobs, creating user-defined events, creating alerts and creating operators. Also checked and maintained database integrity in SQL Server by performing integrity checks on databases, manually shrinking databases, manually shrinking data files.
• Used SQL Server Profiler and System Monitor to monitor instances of SQL Server 2005. Created traces and opened a trace files, monitored CPU usage, created alerts where necessary. Tuned SQL Server databases using Database Engine Tuning Advisor. Used the tool for tuning databases, viewing reports and implementing recommendations. Also used DMVs to look at the state of the server. Queried dynamic management views and functions and used them to view sessions, connections and requests.
• Performed detection and termination of transaction locks by tracking transaction locks terminating locks as needed. Connected to non-responsive databases using the dedicated administrator connection (DAC). This involved using DAC via the sqlcmd utility and using DAC via the Management Studio.
• Ensured greater protection for the database by setting up a database mirroring session which involved creating endpoints, creating logins and granting login permissions, creating a backup and setting the servers. Configure the log shipping options in SQL Server 2005 by enabling the primary database, configuring backup settings, enabling the secondary database and setting monitoring options. Configure replication and configure security by creating a Distributor, creating a Publication, creating a Subscriber and changing logins.
• Backed up a SQL Server databases by choosing a strategy and then backing up the databases. Also performed database restores in SQL Server 2005 by restoring the various databases and Copying the databases between servers
• Performed several and multiple oracle installations identifying all the components to be installed and setting up the Oracle install environment by recognizing how to configure the Oracle install environment using the OUI, DBCA etc. Configured the Oracle Database 10g installation and performed installation on several platforms including Windows and Unix/Linux flavors such as RHEL4/5, CentOS 5, Sun Solaris 9/10 etc.
• Created oracle databases either individually; and with others, coming up with the logical and physical design. Used DBCA for database identification, management, password, and storage options of the various files and logical storage units. Used DBCA to set file locations and parameters. Set database storage settings and creation options, and created or deleted databases using the Database Configuration Assistant.
• Used the Oracle 10g management framework to startup and shutdown several Oracle databases. Set up, modified initialization parameters and viewed the alert log. Controlled the Oracle 10g database by starting and stopping the Oracle Enterprise Manager Database Control, Oracle Listener, and Oracle Database 10g instance. Created, viewed and manipulated tablespaces.
• Administered user accounts by creating user accounts and profiles, granting privileges and assigning quotas to users, and creating a roles and assigning them to users. Implemented database security by making sure that users were authenticated via implementation of password security by configuring user profiles and restricted access to Oracle databases when needed. Monitored database activity using Oracle's built-in audit tools. Implemented fine-grained auditing in several Oracle 10g databases audited overall database activity.
• Created, deleted, and modified tables in an Oracle 10g database. Created indexes, views, and sequences in an Oracle 10g database. Manipulated tables, indexes, and views in an Oracle 10g database. Used Oracle's Data Pump utility to export and import data. Used the SQL*Loader load data.
• Created and configure an Oracle Net Listener, configured local name resolution, configured local Oracle Net Services aliases, configured advanced connection options and test Oracle Net connectivity. Configure, monitored and verified Shared Server.
• Detected and repaired invalid and unusable objects such as indexes. Monitored performance using dynamic performance views, Enterprise Manager, and optimizer statistics. Gathered optimizer statistics for a database schema and set thresholds and baselines for performance metrics. Used various tuning and diagnostic advisors and use the segment advisor to detect storage problems including managing the AWR and using the ADDM to review database performance. Configured several databases for proactive maintenance.
• Managed the undo tablespaces by identifying factors to take into consideration, estimated and calculated required tablespace sizes and resized tablespaces. Managed lock conflicts by detecting and resolving lock conflicts.
• Tuned instance recovery and configured databases for maximum recoverability by configuring and managing databases for backup and recovery. Multiplexed the redo logs, control files and archived redo log files. Also backed up control files to trace. Backed up the databases and recover them in case of failures. Also recovered from the loss of control files, redo log files, and datafiles.
• Oracle II
• Used the RMAN command line to create and manage basic and advanced backups. Implemented several suitable backup strategies by using appropriate commands to manage backups in RMAN.
• Performed appropriate incomplete recovery and recoveries of non-critical files in many scenarios and selected the appropriate detection methods and recovery strategies for database corruption. Ranked appropriate steps and their associated procedures for using DBMS REPAIR. Used the BLOCKRECOVER command to restore data blocks.
• Enabled Flashback features and perform(executed) Flashback Database operations. Identified the recommended steps to perform Flashback Table operations in many instances or situations. Used Flashback features to audit and fix tables. Used the Recycle Bin to perform Flashback Drop operations and to purge items. Determined suitable uses of appropriate Flashback features depending on the circumstances.
• Set the listener passwords and specified who can access a databases. Improved the security for external procedures. Tightened security for the Oracle 10g listener. Used Net Services to connect to databases. Created and used database links and transactions; and viewed information about them. Recognized situations when manual resolution of distributed transactions was required.