We provide IT Staff Augmentation Services!

Sr. Sql Server Dba Resume Profile

PROFESSIONAL SUMMARY

  • 6 years professional DBA experience
  • 6 years SQL Server DBA experience 2000,2005,2008,2012
  • 4 Integration Services, Reporting Services, and Analysis Services
  • 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 2000 to 2005, 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/2008/2012,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 , Percona Server, Xtrabackup, Tungsten Replicator and Enterprise
  • Networking: TCP/IP, LAN/WAN, Ethernet, Token Ring
  • Languages: C , HTML, XML, PHP, Apache, JavaScript, T-SQL, SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential

Sr. MySQL/SQL Server DBA

  • Provide administration and support. Work with business areas and IT developers to troubleshoot and resolve daytime and after-hours support issues in a timely manner as described in IT and business area service level agreements. Facilitate and implement environmental and application changes according to local and national processes and procedures.
  • Designed, planned, and implemented database systems and programs.
  • Administered several aspects of the project such as access methods, device allocation, Installation, configuration, backup and recovery.
  • Provided technical assistance in identifying, evaluating, and developing systems and procedures as they relate to databases, replication setup and configuration and automated backups of such environments.
  • Assignments included design of data dictionaries, database structure and layout, installing, upgrading, and managing database applications.
  • Configured systems for high availability.
  • Ensured the health and performance of MySQL. Performance tuning included working on missing and unused indexes, query optimization, parameter tuning for the MYSQL server and Tungsten.
  • Installed, configured, tested and managed Percona Server, Xtrabackup and Tungsten Continuent Enterprise in the Development, Test, and Amazon Cloud.
  • Launched, created and managed Amazon EC2 instances and Installed MySQL and supplemental MySQL technologies such as Percona Server, XtraDB, InnoDB, Xtra-Backup, and Tungsten Enterprise Replicator.
  • Successfully experienced working in a team-oriented, collaborative and agile environment needing design for latest needs including elastic scalability with the ability to evaluate latest database products and deliver them into the Amazon Web Services cloud for testing before production.
  • Scripted and tested automated backup procedures for MySQL and Tungsten environments and implemented them once successful.

Confidential

SQL Server DBA

  • Provide administration and support. Work with business areas and IT developers to troubleshoot and resolve daytime and after-hours support issues in a timely manner as described in IT and business area service level agreements. Facilitate and implement environmental and application changes according to local and national processes and procedures.
  • Implement and maintain SQL Server databases. Assist in the design of security and integrity controls. Design and analyze distributed computing policies, procedures, and standards. Patching and upgrading installations.
  • Provide consultation to local lines of business and assist them with information technology decisions and implementations.
  • Evaluate and research new information technologies and, when appropriate, recommend the implementation of new technologies to management.
  • Perform daily database maintenance, monitoring, and performance turning tasks.
  • Perform database changes based on the business and application requirements.
  • Work with local and national lines of business to research, implement, and support information technology solutions. Develop and maintains project documentation.
  • Create and update written documentation according to Federal Reserve project and information security standards. Provide management with written status reports for projects and tasks.
  • Identify performance and scaling improvements of Database and document any necessary recommendations.
  • Document and present any other findings or recommendations beyond those specified above

Confidential

SQL Server/MySQL Database Administrator

  • 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 Jazz

  • 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.
  • Demontrate 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 training and mentoring Junior DBA staff.

Confidential

Oracle/MySQL Database Administrator

  • 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.
  • Ensured availability of comprehensive and efficient database in support of company information needs.
  • Coordinated changes to computer databases, tested and implemented the databases applying knowledge of database management systems.
  • Planed, coordinated, and implemented security measures to safeguard computer databases.
  • 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.

Confidential

Data Communications Analyst

  • 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.
  • 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.

Oracle II

Confidential

  • 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.

Confidential

Mortgage Work Director

  • Responsible for contributing to the overall success of the branch through quality leadership by managing a group of processors and closers and making sure that their jobs were completed in helping the company achieve its customer service goals.
  • Use of the bank loan processing database and reports system to achieve my management goals and objectives
  • Pooled, analyzed reports
  • Utilized Queries in order to assemble reports
  • Used LPS database to resolve issues, utilize database, and managed customer issues on a daily basis etc.

Confidential

Network/Database Administrator

  • Administered the SQL Server 2000/2005 databases.
  • Installed and configured SQL Server 2000. Upgraded from SQL Server 2000 to 2005 databases
  • Performed Performance tuning, normalizing, completing modifications, and enhancements
  • Worked with some older Legacy SQL Server 2000 Databases
  • Replicate databases between servers
  • Restored databases and apply transaction logs
  • Applied service packs to fixes of SQL Server 2005
  • Set-up and managed SQL Server Agent jobs
  • Imported and exported data
  • Managed the security of databases
  • Troubleshooting database related issues, identified bottlenecks, and concisely communicated to our client's Development Team

Hire Now