Database Administrator Resume Samples

Description :

1. Supporting the data center move from the children's memorial hospital to the newly built Lurie children's hospital.
2. Defining and implementing SQL onboarding process including a residency policy.
3. Defining and documenting standards for installations, drive layouts, performance benchmarks, file configurations, shared environments.
4. Implementing 9 production and 2 test always-on high availability groups in SQL 2012/2014 which, were a mix of physical and VM servers.
5. Architecting the SQL listener on named instances requiring additional configuration.
6. Designing and implementing the SQL data layer for a network resource allocation and asset tracking application from scratch to handling the hospital network infrastructure of 30,000 network runs and 45,000 devices at the start of the new hospital.
7. Building shared SQL environments in SQL 2008, 2012, 2014 moving away from 1 to 1 application/instance ratio, providing data resources instead of a database server for every need.
8. Supporting the data center move at our dr site from an old internal footprint to the new internal footprint.

Experience

7-10 Years

Level

Executive

Education

MS

Description :

1. Administering database security by creating user logins to different project staff with appropriate roles, monitoring the user accounts, created groups and granted privileges to users.
2. Monitoring and executing RMAN backup and recovery, flashback technology, hot/cold backups, archived redo log files and fast recovering area (fra).
3. Performing day-to-day activities: such as daily error checks and database health monitoring of physical resources (disk space, memory, CPU, etc. ) and performance parameters adjustment as needed.
4. Utilizing RMAN to perform weekly level 0 full backups and daily cumulative incremental level 1 backup.
5. Configuring oracle enterprise manager (OEM) to schedule automatic backups.
6. Involving in database backup and disaster recovery strategies using RMAN and data guard.
7. Providing logical backup of data using oracle data pump utilities (EXPDP and IMPDP) to transfer data from a database or schema to another.
8. Performing database refreshes, cloning, and duplication from one oracle database to the other.
9. General database administration including management of instances, redo logs, tablespaces, temp space, rollback/undo segments and schema management.
10. Coordinating with engineering and database architects in analyzing automated workload repository (AWR) reports and ADR diagnostic utility to improve database response times.

Experience

10+ Years

Level

Senior

Education

MBA

Description :

1. Control migrations of programs, database changes, reference data changes and menu changes through the development life cycle.
2. Implement and enforce security for all of the oracle databases; the three basic security tasks are authentication (setting up user accounts to control logins to the database), authorization (setting permissions on various parts of the database), and auditing.
3. Developed and tested storage strategies and disaster-recovery plan for operational database, delivering a solution that guaranteed recovery performance and high availability.
4. Reorganized databases and sized database object to meet standards and improve performance.
5. Experience in database server tuning, application tuning, maintaining documentation, capacity planning.
6. Performed database tuning, created database reorganization procedures, scripted database alerts, and monitored shell scripts.
7. Administration of instances of oracle 10g/11g databases supported on the Unix, oracle Solaris, IBM Aix, hp-UX and windows environments.
8. Oracle 10g migration to oracle 11g: selecting the instance to upgrade, analyzing the existing database to make sure it is suitable for the upgrade, creating the Sysaux tablespace which is required for 11g basic proficiency on Linux.
9. Performed database duplication for both file-based and ASM based database using RMAN.
10. Develop database structure, implement applications, enhance the system and ensure security.

Experience

0-2 Years

Level

Entry Level

Education

B.Tech

Description :

1. Provided day to day operational and technical supports for the databases (prod/dev/UAT) and applications issues under oracle RAC 11g/10gr2 enterprise grid control environments.
2. Installed, configured and maintained newly created databases (oracle 12c/11gr2 and Sybase 15. X) required for development and testing purposes.
3. Setup vendor recommended databases and applications monitoring tools oracle 11gr2 enterprise manager (OEM), fog lights and setup database health alert system.
4. Setup databases disaster recovery systems such as oracle 11gr2 (RAC), data guard (active data guard) o monitored the performance of the running production databases (including Sybase control center, PostgreSQL, Oracle Exadata, and OLTP), a user connected session's activities, locks, latches, alert. Log, block corruptions, segment fragmentation, security threats, and tune databases when it was needed.
5. Lead the team members (offshore applications developers), wf ICMP applications (Iowa farming mortgage and loan) deployment and provided project progress to the project manager during the weekly meeting.
6. Controlled migrations of all database programs (oracle 11gr2), especially database changing, reference data changing and menu changing through the development life cycle.
7. Migrated existing old databases (IBM db2, SQL server2005, Sybase, oracle 8i, and oracle 9i) to new oracle 11gr1/r2 database environments using available wells Fargo provided tools and techniques like oracle golden gate tools (manager, extract, pump & replicate processes), Oracle SQL Developer, and Swiss SQL.
8. Initiated change management procedure and released new changes into productions and nonproduction database systems environments.
9. Implement database auditing, data security and remediate high-risk violation in the production environment.

Experience

0-2 Years

Level

Entry Level

Education

BS

Description :

1. Providing tier III senior systems engineering support for all back-end & front-end windows 08 r2 servers and SQL 08 r2 servers & clusters and 2012 servers.
2. Comprising of multiple separate instances of blackboard environments, each servicing different sections and directorates within the army.
3. Responsible for performing all after-hours server maintenance, which occurs a minimum of two times per month.
4. Monitoring performance and manage parameters to provide fast responses to front-end users.
5. Responsible for creating technical reports using ms SQL data and presenting to upper management.
6. Field requests from front-end users when data is needed, and write custom t-SQL queries to retrieve the data.
7. Analyzing and solving complex problems related to the blackboard application such as troubleshooting content related playability issues, web browser compatibility issues, content collection uploads, and application performance issues.

Experience

5-7 Years

Level

Executive

Education

BA

Description :

1. Member of 10 people award-winning technical support team, providing rotating 24/7 support and problem resolution for 100+ healthcare sites with SQL server database installations from several GB to hundreds of GB.
2. Batch and VBS Powershell scripts to perform database backups as scheduled tasks.
3. Configuration of SQL server transactional replication on 50+ clients, with multiple subscribers.
4. Setting up SQL server mail profiles, with jobs to generate reports of successful/failed replications.
5. Installation of SQL server 2008r2, 2012 and 2014, service packs and cumulative updates.
6. Configuration of SQL server security, domain and application logins, schemas, user permissions, and privileges.
7. Designing maintenance plans, customized to specific database usage.
8. Data growth rate, index fill factors, data retention policy and identification of data access "hot spots".
9. Support: amongst the lowest IRT (initial response time) and TTR (time to resolution) within the support department, maintaining less than 2 hours IRT and 48 hours TTR.
10. Averaging 10+ support ticket resolutions per day, with overall support team volume of 150+ incidents per day.

Experience

10+ Years

Level

Senior

Education

MS

Description :

1. Setup always-on high availability on 2012 SQL servers.
2. Migrating SQL server from 2008r2 to 2012 on standalone and cluster environment.
3. Identify locking and blocking issues using extended events and SQL profiler tuning the production server to get the performance improvement.
4. Implemented database mirroring/transactional replication as a part of high availability and disaster recovery.
5. Implementation of SQL logins, roles and authentication modes as a part of security policies for various categories of users.
6. Restore development and staging databases from production backups as per the requirement.
7. Creating backup strategies and scheduling them as a part of database maintenance plans.
8. To analyze long running slow queries and tune the same to optimize application and system performance.
9. Planned the complete backing up of database and restoring the database from disaster recovery.
10. Documented and created SLAs (service level agreement) for the server availability in case of disaster.

Experience

7-10 Years

Level

Management

Education

B.Tech

Description :

1. Monitoring and maintaining large scale (1000+) databases and 45+ SQL servers maintain a mix of standalone and clustered SQL instances plans, performs, and monitors database backups.
2. Standardizing the implementation of databases and improves management of dau production and test environments.
3. Involving in installing, configuration and administration of SQL server 2005 & 2008& 2012 as well.
4. Providing support to application developers in designing and implementing physical database structures.
5. Writing stored procedure to audit SQL servers, establish and enforcing security auditing mechanism and performance tuning, optimization researched, designed and tested a migration plan from SQL server 2008 to SQL server 2012.
6. SQL server performance statistics collection, server monitoring, and performance tuning.
7. Database capacity planning, maintenance planning, SQL agent jobs scheduling and troubleshooting.
8. Implement and maintain database security, replication, stand by the server, DTS, log shipping, SQL mail manages small, medium and large SQL server 2000 projects.
9. Experience writing SQL queries, stored procedures, triggers, and functions, creating tables, views, and indexes involved in installing, configuration and administration of SQL server 2012.
10. Provide support to application developers in designing and implementing physical database structures.

Experience

10+ Years

Level

Senior

Education

BS

Description :

1. Tackle MSSQL dba support problems in 24/7 remote environment for the company's strategic solutions/system solutions/data center/managed services division supporting 2,000+ customers.
2. Managing 50+ instances of SQL server including performance monitoring, optimizations, backups, error and alert checking, and windows os support.
3. Designing, installing and recommending best practices for new customer databases.
4. Leveraging knowledge of best practices and SQL 2005/sql 2008 installations to test and develop the installation process for SQL 2008 r2.
5. Enabling new offering using NetApp by learning the product and developing a process for snap manager including installation and documentation of a repeatable process.
6. Gained SharePoint product knowledge to improve the support of databases required for the back-end of Sharepoint 2007.
7. Participating in the cross-functional team designing a new change management process.
8. Subsequently selected for change management administrator to implement and continuously improve the process across all technical areas.
9. Cdw (continued) representative projects situation: customer databases required migration from SQL 2005 to SQL 2008.
10. Creating, tests, and implementing a migration plan to move jobs, users, and data.

Experience

10+ Years

Level

Management

Education

BS

Description :

1. Implementing the code using the DBCR process and automate the script to deploy the code in a higher environment.
2. Using the SRDF process to sync up the data guard and using the SCN backup method to sync up the data guard.
3. Setting up the new data guard after the creation of a new database, and do failover and switch over based on the requirement.
4. Install, configure and support uni-directional oracle-to-oracle replicated environments utilizing golden gate for reporting.
5. Using the golden gate process to masking the sensitive data for reporting.
6. Masking the critical sensitive data using oracle masking process and implement the full automation of the masking process using Emcli tool.
7. Applying the PSU patch every quarterly for every prod and the lower environment in the database and yearly on the cluster using rolling fashion.
8. Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.
9. Managing appropriate use of free space within tablespaces, reclaimed space whenever possible.
10. Creating the 12c multitenant cluster database for new application and provide the end to end support to configure the application to connect the 12c database.

Experience

5-7 Years

Level

Executive

Education

Associate