FIND PERSONALIZED JOBS
Sign up to Zippia and discover your career options with your personalized career search.
Sorry, we can't find that. Please try a different city or state.

Senior Database Administrator

This job has expired and is no longer available.
APPLY NOW
Apply Now
×
FIND
PERSONALIZED JOBS

Sorry, we can't find that. Please try a different city or state.

CONTENT HAS
BEEN UNLOCKED
Close this window to view unlocked content
or
find interesting jobs in

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign Up

SIGN UP TO UNLOCK CONTENT

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Forgot Password?

Don't have an account? Sign Up

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign up to save the job and get personalized job recommendations.

Sign up to dismiss the job and get personalized job recommendations.

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Already have an account? Log in

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Company Saved

Answer a few questions and view jobs at that match your preferences.

Where do you want to work?

Job Saved

See your Saved Jobs now

or

find more interesting jobs in

Job Dismissed

Find better matching jobs in

Your search has been saved!

Top 50 Senior Database Administrator Skills

Below we've compiled a list of the most important skills for a Senior Database Administrator. We ranked the top skills based on the percentage of Senior Database Administrator resumes they appeared on. For example, 19.7% of Senior Database Administrator resumes contained Database as a skill. Let's find out what skills a Senior Database Administrator actually needs in order to be successful in the workplace.

These are the most important skills for a Senior Database Administrator:

1. Database

demand arrow
high Demand
Here's how Database is used in Senior Database Administrator jobs:
  • Implemented Oracle database securities in accordance to validated system governed by Food and Drug Administration.
  • Provided support to Application Database Administrators in designing the database.
  • Develop and maintain Database disaster recovery plan.
  • Participated in the physical database design, coding, testing and implementing SQL code, infrastructure, web and application server.
  • Analyze SQL execution plans, missing indexes and updating statistics of the databases by working closely with the database developers.
  • Implemented a More Solid and Robust Database Backup and Recovery Solution for over 700 Servers in our Organization.
  • Monitored database migration, database growth monitoring, schedule Job maintenance, troubleshooting User Query.
  • Worked with developers and end users to solve problems or issues related to database systems
  • Audited accessing database objects, such as users, tables, or indexes.
  • Configure Log Ship to create warm standby server for production database.
  • Provided support for all ALTESS database operations in local group.
  • Upgrade SQL Server 7.0 server databases to SQL Server 2000.
  • Applied database level encryption using TDE for user databases.
  • Supported ALTESS database group on base.
  • Support of 175+ database instances.
  • Evaluate the effectiveness of database management technology, and investigate systems problems and inefficiencies.
  • Performed database maintenance duties like DBCC, database full & differential backup, transaction log backup and Disaster recovery.
  • Create and maintain Logins, granted and revoked permission, Schedule Jobs, databases and database objects.
  • Created UNIX scripts to control backups, database consistency checks, replication synchronization, and Login synchronization.
  • Handle Requests and issues on Logins, Database User access, Security permissions.

Show More

184 Database Jobs

No jobs at selected location

2. Pl/Sql

demand arrow
high Demand
Here's how Pl/Sql is used in Senior Database Administrator jobs:
  • Designed and developed interface (using PL/SQL and shell scripts) to exchange data between e-commerce database and customer database.
  • Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
  • Provided advice on data modeling, partitioning, indexing, queries, and PL/SQL code to improve performance.
  • Created PL/SQL stored procedures, functions and packages for moving the data into staging area.
  • Worked on PL/SQL optimization for faster execution and better performance of the Database.
  • Tuned PL/SQL code for faster execution and better performance of the Database.
  • Optimize developer's SQL and PL/SQL on single program and overall application.
  • Developed PL/SQL triggers and master tables for automatic creation of primary keys.
  • Write T-SQL and PL/SQL stored procedure codes for data movement.
  • Fined tuned all existing PL/SQL coding for performance optimization.
  • Utilized PL/SQL and T-SQL languages on multiple client sites.
  • Design and convert Pro*C programs to PL/SQL packages.
  • Tuned performance of batch jobs and PL/SQL.
  • Created Shell, SQL, and PL/SQL code for moving data between databases (via TTS).
  • Used T-SQL and PL/SQL for coding.
  • Generated server side pl/sql scripts for data manipulation and validation and materialized views for remote instances.
  • Work with the development team in troubleshooting pl/sql issues and during deployments.
  • Modified PL/SQL and exp/dmp process for performance increases.
  • Created PL/SQL scripts for application and dictionary queries Created and modified UNIX scripts under Korn shell.
  • Developed logic within pl/sql packages and procedures to send emails containing profile data to Apex users with the utl_smtp api.

Show More

3. Recovery Procedures

demand arrow
high Demand
Here's how Recovery Procedures is used in Senior Database Administrator jobs:
  • Develop database backup/recovery procedures, and conduct regular DR tests while providing support to business operational models.
  • Design, Implement, and Document automated Backup/Restore, database maintenance and Disaster Recovery Procedures.
  • Develop backup and recovery procedures, designs database security, and configures database storage devices.
  • Performed Database Backups using Backup Compression, Recovery Procedures and Disaster Recovery plans.
  • Planned, prepared and tested backup and recovery procedures for both production/non-production databases.
  • Design and execute database backup and recovery procedures including disaster recovery.
  • Developed and tested all disaster recovery procedures for all functional systems.
  • Documented disaster recovery procedures and participated in planned disaster recovery exercises.
  • Implemented and maintained SQL Server database backup and recovery procedures.
  • Developed and documented formal DB2 Backup & Recovery procedures.
  • Designed and tested Disaster recovery procedures for several applications.
  • Set up Backups mechanism and documented recovery procedures.
  • Improved and documented database backup and recovery procedures.
  • Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups.
  • Performed routine maintenance and testing of Backup/Restore and Disaster Recovery Procedures for Oracle and SQL Server.
  • Develop, document, test and implement database Disaster Recovery procedures for all Revlon databases.
  • Implemented RMAN backup and recovery procedures.
  • Created database backup and recovery procedures using SQL Backtrack on a VERITAS Clustered Sun Solaris environment.
  • Automated Backup & Recovery procedures using UNIX shell scripts and PL/SQL Scripts through cronjobs.
  • Standardized and refine the restore/recovery procedures to reduce the hours of rebuilding the system( including Oracle Cluster, ASM.

Show More

1 Recovery Procedures Jobs

No jobs at selected location

4. SQL

demand arrow
high Demand
Here's how SQL is used in Senior Database Administrator jobs:
  • Work on the analysis, planning and deployment process of database migration from SQL 2005/2008.
  • Developed and implemented Oracle and MySQL backup retention strategies and policies for PNC.
  • Work with application teams to tune SQL both for projects and in production.
  • Installed and configured SQL development, testing, implementation and production servers.
  • Developed and implemented MySQL HA and DR architectures for PNC using MHA.
  • Programmed in SQL for column level encryption/decryption to secure client data.
  • Helped pioneer our department's migration to MSSQL 2005 and 2008.
  • Provided 24 X 7 dedicated supports for SQL Server production server.
  • Work closely with solution architect to implement required SQL solutions.
  • Installed Oracle Gateway 11gR1 to pull data from MSSQL server.
  • Develop SQL 2005/2008 stored procedures, jobs, views, triggers, and back up plans.
  • Tested SQL, batch jobs, utilities and programs during the three modes of V8 testing.
  • Lead SQL 2008 to 2012 upgrade project for over 200 SQL instances.
  • Clustered and non-clustered index creation/optimization using SQL Profiler and Index Tuning Wizard.
  • Create and manage SQL Backup Maintenance policies using Idera's SQL Safe backup tool set.
  • Manage multiple Production and uat SQL servers in AWS environment.
  • Provided HA with log shipping for stand alone SQL servers.
  • Apply SQL Server service packs and hotfixes.
  • Utilize SQL Server Profiler to detect issues.
  • Architected and built SQL Multi node HA/DR Design using SQL AlwaysOn (AG).

Show More

140 SQL Jobs

No jobs at selected location

5. DBA

demand arrow
high Demand
Here's how DBA is used in Senior Database Administrator jobs:
  • Served as Performance Tuning DBA on a large Oracle Applications implementation at a software development firm in Chicago, IL.
  • Led the DBA team in the design, coding and implementation of the standard scripts for Oracle databases.
  • Provided all kinds of DBA support to development teams as well as production support to various applications.
  • Authored DBA documentation covering standards, procedures, best practices, and db reference material.
  • Worked on DBA Shared Services Team for Single Family and Multifamily Database Support Team.
  • Performed Application DBA role for Oracle Application Implementation of version 11i and 11.0.3.
  • Provided primary DBA support for development of new Web product.
  • Mentored junior level DBA's and interns at multiple locations.
  • Document and train DBA's on backup and restore procedures.
  • Provide dedicated DBA support for assigned projects.
  • Implemented Yearly DBAR Testing for Disaster Recovery.
  • Pinpoint Consulting - Charlotte, NC 8/2002 - 9/2002 Position: Oracle DBA Consultant.
  • Lead DBA in a 24 x 7 environment.
  • Managed 4 junior DBA's.
  • Developed and implemented DBA processes based on industry best practice, in areas such as communications, monitoring, and documentation.
  • Provide dedicated DBA support for assigned projects to include Siebel CRM, BCP/DR, and SQL Server upgrades.
  • Position: Senior Consultant/Primary Remote DBA Served as Primary Remote DBA for dozens of clients remotely.
  • Lead DBA for Nielsen's Security Policies surrounding RedBrick and Netezza for compliance.
  • Turn to be the LEAD DBA for 19 co-workers and Principal DBA for Scalation on SQL Related Issues.
  • Lead IMS DBA DB/2 DBA 24 x 7 support for production and test environments Recovery of damaged systems

Show More

77 DBA Jobs

No jobs at selected location

Job type you want
Full Time
Part Time
Internship
Temporary

6. Windows XP

demand arrow
high Demand
Here's how Windows XP is used in Senior Database Administrator jobs:
  • Maintain 20+ production instances on Windows XP/2003/2008 running Oracle 10g/11g that provide data to public-facing Web sites and various internal departments.
  • Administered Windows XP Pro and Red Hat Linux (Fedora 10).
  • Support for Windows XP, Microsoft Office Suite and Internet Explorer.
  • Developed and tested Heat Database 7.0 for compatibilities running Windows XP.

Show More

7. High Availability

demand arrow
high Demand
Here's how High Availability is used in Senior Database Administrator jobs:
  • Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.
  • Experience performance and high availability management in Windows clustering environment with Paragon and various other system.
  • Implemented high availability replication across different cities; performed logical and physical logging of the databases.
  • Implemented database high availability through setup and maintain real-time bi-direction replication using Quest SharePlex.
  • Configure and administer the VERITAS Cluster Server technology for high availability systems.
  • Developed and maintained High Availability solutions.
  • Managed and supported the FPL Energy marketing database which used Oracle Parallel Server 8i (OPS) for high availability.
  • Provide ongoing high availability support for IBC's Internet Banking and Check Imaging Systems which operate in SQL Clustered environment.
  • Implemented the high availability and disaster protection for all the production databases using the Oracle Data Guard feature.
  • Administered and supported Oracle 10g, 9i, 8i high availability databases in production, development and UAT.
  • Involved in managing log files and thereby ensuring high availability of database in a 24X7 scenario.
  • Installed and configured Oracle 10g Data Guard using physical and logical standby for high availability databases.
  • Implemented High Availability solutions like hardware clustering, physical standby databases, and Data Guard.
  • Experience in implementing High Availability solutions using SQL Clusters, Replication, and Log Shipping.
  • Installed oracle server binaries and configured RAC with RAC Standby Databases for high availability.
  • Manage Microsoft Clustering, Log shipping, Transaction Replication and High Availability AlwaysOn Design, Implement and manage database backup/recovery process.
  • Involved in disaster recovery planning Intensively worked and managed SQL server high availability like clustering, database mirroring, and replication.
  • Configured Oracle Goldengate to support unidirectional and Bi-directional replication of database for reporting and high availability.
  • Used Oracle Internet Directory to leverage the scalability, high availability and security features of the Oracle database.
  • Implemented Stream, Golden Gates for Active-Active Replication between the Datacenter for High Availability.

Show More

53 High Availability Jobs

No jobs at selected location

8. Linux

demand arrow
high Demand
Here's how Linux is used in Senior Database Administrator jobs:
  • Installed and configured Oracle 12c (Oracle Enterprise Manager) server for monitoring database servers and databases on Linux 5.8 OS.
  • Installed and configured Red Hat Linux, NetApp storage, and Oracle9i RAC databases as well as Advanced Replication systems.
  • Implemented Oracle 11g RAC (3 node) systems in HA environment in Linux & also in Virtual Machines.
  • Fast provisioned over 30 virtual machines running Linux x86 for non-production and production systems.
  • Provide operational support of CentOS Linux and MySQL on over 2,400 high-traffic servers.
  • Configured the Oracle GoldenGate on Oracle Enterprise Linux 6 for data replication.
  • Install MySql in Linux, create database etc in testing environment.
  • Install and patch/upgrade Oracle 11g software on Linux OS.
  • Installed and Configured Oracle VM on Linux.
  • Managed over 300+ databases on Solaris, Linux, Windows 2003 Server environments with sizes up to 2 + T.B.
  • Completed Data Center move, migrated Oracle 9i from Sun Solaris to Oracle 11g on Linux via Oracle GoldenGate replication.
  • Installed, configured and administered Oracle 10g Real Application Clusters (RAC) on Linux, Sun Solaris.
  • Install and configure Oracle Data Gateways [ ] in RedHat Linux environment to connect to MySql.
  • Worked on Migration of databases from 10g Standalone/ RAC to 11G RAC from Solaris to Linux.
  • Installed and configured Oracle 11g RAC databases on Linux and Failsafe on Windows servers.
  • Worked with Solaris, Linux, HP-UX flavors of Unix.
  • Migrated oracle databases from HP-Unix, Solaris to Linux.
  • Worked with Redhat Support on resolving Linux issues.
  • Performed cronjobs mostly backup jobs using crontab utility in Linux Operating System.
  • Installed Oracle 10G RAC on Linux platform and worked on 10G RAC switchover and failover configuration, implementation, and testing.

Show More

14 Linux Jobs

No jobs at selected location

9. Unix

demand arrow
high Demand
Here's how Unix is used in Senior Database Administrator jobs:
  • Installed & configured Tuxedo 11g R1, Web Logic 11g R1 and Micro focus Server Express COBOL 5.0 on Unix environments.
  • Developed numerous UNIX shell scripts to handle database replication jobs, backup database files, and monitor database performance.
  • Install and maintain Oracle server; create database on UNIX and NT platforms.
  • Worked with UNIX team in setting up HACMP environment for database servers.
  • Generated PL/SQL reporting and Unix Scripts to notify process failure/success.
  • Carried out disk space maintenance on various UNIX servers.
  • Use ASET to monitor standard UNIX security violations.
  • Assisted UNIX team with their patch upgrades.
  • Created Databases DEMO, DEV, TEST and CONFIG databases on UNIX.
  • Developed and updated Unix scripts containing the following: o Batch file processing utilizing KERMIT file transfer protocol.
  • Configured LDAP server extension for OUD Wrote Unix Shell Scripts to process the files on daily basis.
  • Configured sybase XP servers to enable ability to execute Unix shell commands from ASE servers.
  • Created UNIX shell scripts and created cron jobs for automating database refreshes utilizing export/import utilities.
  • Escalate where and when necessary Excellent experience of SQL and PL/SQL and Unix Shell scripting.
  • Worked with puppet team to write unix script for automation.
  • Provided Statistical and analytical support through graphical representation of performance database and unix systems.
  • Performed TCP benchmark testing on SGI Unix machine with Baydel Raid to determine disk subsystem metrics.
  • Used UNIX telnets and XWindows sessions manage and navigate in the MP-RAS environment.
  • Created UNIX shell scripts for collecting database performance statistics using vmstat, iostat, ps.
  • Performed camouflage install on Windows, unix platform and Vormetric core guarding on unix servers.

Show More

6 Unix Jobs

No jobs at selected location

10. Rman

demand arrow
high Demand
Here's how Rman is used in Senior Database Administrator jobs:
  • Implemented intelligent techniques in application logic to help database performance improvement and overall application performance improvement.
  • Involved in physical database design, query optimization and other performance related issues.
  • Performed other DBA activities like including space management and performance monitoring.
  • Performed performance analysis and performance tracking.
  • Prepared and maintained the documentation of all the installation, configurations, Upgrade and Performance tuning of databases and applications.
  • Managed database instances, monitor server performance, tuned the database server and applications, and performed backup and recovery.
  • Implemented and validated McNeil's database performance standards by implementing the available Oracle 9i new performance features.
  • Involved in the Performance of the databases and application by creating multiple domains across the instances.
  • Performed performance tuning of Oracle RAC, Data Guard and MySQL databases in all environments.
  • Worked on different types of cloning including cold backup/hot backup and RMAN Cloning.
  • Developed different shell scripts for RMAN backup, and other database activities.
  • Tuned poorly performed SQL queries to achieve 99% performance improvement.
  • Set up backup and recovery plans and monitor system performance.
  • Subject matter expert for our performance solutions data team.
  • Level 0 and Level 1 backup configuration using RMAN.
  • Used RMAN for backup and recovery.
  • Debugged issues during the RMAN restore.
  • Provided operational analysis, guidance, and support on financial and non-financial performance metrics.
  • Implemented RMAN Backup configurations using catalog database with NetBackup tool Applied Security Patches for Oracle databases Performed Test Database Refresh/Cloning activities.
  • analyzed data stored in numerous databases, made recommendations relating to performance and efficiency of that data storage, etc.)

Show More

21 Rman Jobs

No jobs at selected location

11. Capacity Planning

demand arrow
high Demand
Here's how Capacity Planning is used in Senior Database Administrator jobs:
  • Conducted database capacity planning for several data centers to include 3 Major data centers with Production and Non-Production environments.
  • Customize Database monitor and statistics for production troubleshooting and capacity planning.
  • Performed capacity planning and space management.
  • Performed capacity planning for new databases.
  • Coordinated database checkpoint frequencies, archive logging, resource usage with programming and system administration staff; Created capacity planning forecasts.
  • Experienced in capacity planning, setting up environments, API's, Network latency and user privileges using DELPHIX Engine.
  • Developed performance testing plan and strategies, responsible for capacity planning strategies for all Oracle systems.
  • Created various scripts for capacity planning by calculating future space consumption by each mount point.
  • Produced first generation capacity planning reports and metrics, working with resources in Brazil.
  • Involved in Capacity Planning, Tuning the RAC interconnect, Finding RAC wait events.
  • Managed and performed capacity planning for both initial setups with projection for future growth.
  • Perform capacity planning/space analysis and performance tuning of SQL Server 2005/2008 R2 Databases.
  • Managed capacity planning, resource utilization, system resilience, and performance tuning.
  • Optimize and tune database performance and provide for capacity planning and technical design.
  • Involved in Capacity Planning for databases based on the future business growth requirements.
  • Worked on proactive capacity planning and tending reviews of all oracle databases.
  • Involve in Capacity planning and storage system design for large databases.
  • Involved in capacity planning, sizing and database growth projections.
  • Load Modeler provides real-world performance testing, scalability assessment, and capacity planning for Web applications inside and outside the firewall.
  • Resolved low disk space issues on mysqltmp directory, implemented capacity planning of new MySQL servers.

Show More

33 Capacity Planning Jobs

No jobs at selected location

12. Setup

demand arrow
high Demand
Here's how Setup is used in Senior Database Administrator jobs:
  • Experience in database performance monitoring, tuning and GoldenGate configuration and setup.
  • Configured ESM security setup and base line security violations.
  • Converted single instance databases to 2-node RAC database, Setup Oracle 11G RAC databases on 2 nodes Linux server.
  • Create databases, setup security, and DB monitoring, troubleshooting, performance tuning, backup, restore recovery.
  • Worked on Golden gate end to end setups and monitoring and maintain the GG Replication.
  • Designed and setup all database environments infrastructure to leverage the usage of NAS storage.
  • Played major role in design and setup of cluster environments for new products.
  • Handled all critical projects and setup end to end SQL servers.
  • Installed and setup active-passive Oracle cluster using VCS.
  • Design and setup database architectures and backups.
  • Created setup to automate backup activities.
  • Performed database cloning to setup test and development databases.
  • Worked on mysql replication setup and troubleshooting replication issues.
  • Provide guidance to business on information security best practice, initial setup of new users and new functionality before systems.
  • Worked with UNIX system admin to move databases from standalone to cluster configuration and setup/test the failover configuration.
  • Created & configured UNIX/Windows environments to setup databases and PeopleSoft installation on AWS-Amazon Work Space.
  • Worked on Replication server for setup and monitoring of Warm Standby and adhoc replication.
  • Configured & setup integration broker between Financials, ELM and HCM Applications.
  • Worked on installing weblogic /oracle application server Worked on Node Manager, work manager setup on application server.
  • Install Oracle Financial Applications 11.5.9; Oracle Financials and Procure to pay Applications And iExpense applications, C-based Work-flow mailer setup.

Show More

3 Setup Jobs

No jobs at selected location

13. RAC

demand arrow
high Demand
Here's how RAC is used in Senior Database Administrator jobs:
  • Support and Administration of Oracle Discoverer and Reports performing upgrades and application tuning.
  • Worked with application teams and developed Oracle Security Fine Grained policies for restricting access to sensitive or private data in database.
  • Implemented Active Data guard, creating both Logical and Physical Standby databases in 11gRAC environment for the Production databases.
  • Support database installation, creation and maintenance in Oracle 10g (10.2), and Oracle 11g.
  • Involved in Installation and configuration of Oracle 10g &11gR2 RAC using Cluster ware and ASM.
  • Created and configured Real Application Cluster using raw device file structure and Oracle Cluster Manager.
  • Developed shell script to provide reliable backups and cleanup archive logs utilizing Oracle RMAN.
  • Direct interaction to users & client & to fulfill their requests ASAP.
  • Installed and configured Oracle SQL Developer to provide access for Software Developers.
  • Experienced in Oracle Database monitoring, troubleshooting and resolve the issues.
  • Installed, maintained, and supported 9iASand OAS10g to support Oracle Discoverer
  • Applied patches to Oracle Databases and Oracle Applications.
  • Implemented Oracle's first time entry product.
  • Upgraded four Oracle 10g databases.
  • Developed HP MC/Service Guard oracle scripts to implement the Oracle 9i failover within the client's requirement of zero downtime.
  • Participated in the migration of nine databases from Informix 9/10 to Oracle 11.2.0.1 in the Linux/VM Ware environments.
  • Created a Customized Monitoring Tool for Tracking Maintenances and Health for over 5K Databases.
  • Migrated 10g database from Solaris to Red Hat Linux and Oracle 11g.
  • Lead team and participates in performing Oracle installations on Solaris and Windows servers, including databases, middleware and web servers.
  • Participated in the monitoring and maintenance of several Oracle 11g R2 databases across a Solaris/Unix and Linux/VM Ware environments.

Show More

30 RAC Jobs

No jobs at selected location

14. Data Warehouse

demand arrow
high Demand
Here's how Data Warehouse is used in Senior Database Administrator jobs:
  • Implemented and maintained variety of database systems including Oracle/SQL Server Data Warehouse systems.
  • Created multiple Data Warehouses and Multidimensional databases for many clients.
  • Developed data warehouse models for accounting, operations and marketing.
  • Support for two 10 node Oracle Real Application Clusters with load balancing using Oracle services for real time data warehouse application.
  • Imported data from MySql 5.6 to SQL Server 2014 using SSIS packages for the enterprise data warehouse (EDW) project.
  • Manage & responsible for Oracle Data warehouse from knowledge manager of Symbols of Sun Products for core banking system.
  • Lead architect and developer for the implementation of real-time data replication feeds from OTLP databases to data warehouse.
  • Utilized Oracle Data Replication Service between Microsoft SQL Server based data source to the Oracle data warehouse.
  • Develop source to target mappings, process flows for migrating data into Data Warehouse staging area.
  • Participated in the design and implementation of a Claims Data Warehouse running on Oracle 7.
  • Mentored several junior DBA's at the corporate office regarding the Enterprise Data Warehouse.
  • Performed Oracle DBA role on Data Warehouse production, development and test servers.
  • Created and scheduled Materialized View jobs for data warehouse loads and refresh.
  • Utilized Star and Snowflake schema's while creating these data warehouses.
  • Maintain and develop ETL tools for data warehouse and market database.
  • Architected and implemented GoldenGate replication between SQL Server data warehouse and Oracle capacity and performance management repository.
  • Contracted by Tricon to support Y2K efforts and data cleansing for the Pizza Hut data warehouse project.
  • Migrated MySQL application and tables to SQL Server 2005 Increased the effectiveness of the Data Warehouse:
  • Set up a new virtualized SQL Server 2008R2 Report Server / Data Warehouse.
  • Support Development Lifecycle of SNEI applications on OLTP and Data Warehouse Exadata systems for large clustered Oracle databases.

Show More

12 Data Warehouse Jobs

No jobs at selected location

15. Ssis

demand arrow
average Demand
Here's how Ssis is used in Senior Database Administrator jobs:
  • Deploy SSIS packages in production environments by participating in application and database deployments for different products throughout the organization.
  • Install Change Assistant and involved in creating copy of Production for Initial Pass and Move to Production for the Upgrade Process.
  • Created SSIS Packages for Georgia Pacific saw mills in Mississippi and Texas to push data to displays throughout their facilities.
  • Developed and assisted in Analysis services cubes, stored procedures, user defined functions, indexes and indexed views.
  • Worked with SSIS, helped developers with migration of DTS packages from SQL 2000 into SSIS in SQL 2005.
  • Assisted management in utilizing the services of using both local and global DBA resources to better service customers.
  • Configured Change Assistance for initial upgrade with PeopleSoft 9.1 to 9.2 delivered templates.
  • Download Template from customer connection, Created & configured Job in Change Assistant.
  • Provided assistance and support to the application development teams on Microsoft best practices.
  • Assist Application and Product Development Manager in the testing of application releases.
  • Assisted UNIX System Administrators in configuring database servers and client machines.
  • Download Template from Metalink3, Create a Job in Change Assistant.
  • Assisted with production migration and continuing support of all Oracle platforms.
  • Performed SQL tuning and assist developers with coding PL/SQL.
  • Create and install SQL Server Jobs and SSIS packages.
  • Run Change Assistant for Tools and Application Upgrade.
  • Design and Manage SSIS packages for development team.
  • Installed Upgrade Assistant and Change Assistant.
  • Created ssis package to migrate data between databases.
  • Assisted &supported PeopleSoft Application Versions [ ] the testing phase.

Show More

8 Ssis Jobs

No jobs at selected location

16. Solaris

demand arrow
average Demand
Here's how Solaris is used in Senior Database Administrator jobs:
  • Administered lab consisting of Solaris, Linux and windows platforms supporting multiply databases.
  • Provided backup support for Solaris UNIX system administrator.
  • Performed systems and database administration using Oracle/Solaris systems.
  • Write scripts to monitor databases, web servers, disk space, and scheduled jobs on Solaris systems 2.6 and 2.7.
  • Worked for Citigroup Private Banking (CPB-US) remote support Project which is a 24/7 operations servers on Unix/Solaris Environments.
  • Upgrade databases from 9i to 10g, 10g to 11g on Sun Solaris, Linux and Windows operating systems.
  • Completed physical design and layout of the production database server under Solaris to effect huge performance gains.
  • Researched, documented, tested and migrated from Oracle V7 database to Oracle8i on Unix Solaris.
  • Installed 11.2.0.2 for WFX applications and 11.1.0.7 DB's for SLBOS application, both Solaris.
  • Performed installs of Oracle 10g and 11g on Solaris 9 and Red Hat 5.5.
  • Created Databases DEMO databases for HRMS 9.0/9.1People Tools 8.49.22 and 8.51.10 on Sun Solaris.
  • Installed and configured all components on Solaris and Linux, Windows environment.
  • Installed and tuned multiple 9i systems, both on HP-UX and Solaris.
  • Supported Boeing JSF program in Oracle s 8i release on Sun/Solaris platform.
  • Monitor and maintain Oracle production databases on Solaris and Windows servers.
  • Installed and maintained 2/3 node RAC database on Sun Solaris.
  • Installed and upgraded Oracle 8i running on Solaris.
  • Installed, administered, upgraded and tuned Informix 9.20 running on Solaris 2.6.
  • Monitored Solaris and worked closely with Solaris 10 SysAdmin.
  • Maintained the availability and health of Oracle database systems and resolve database problems on Solaris, RHEL and Oracle Exadata servers.

Show More

10 Solaris Jobs

No jobs at selected location

17. ETL

demand arrow
average Demand
Here's how ETL is used in Senior Database Administrator jobs:
  • Developed scripts to analyze database integrity and assure successful completion of ETL processes.
  • Automated processes for data imports/extracts (internal and external), using replication, ETL, FTP, and other tools.
  • Experimented with changing buffer pool and table space page size to improve time taken by ETL to build data marts.
  • Trained new and existing employees on database concepts, SQL, ETL tools, reporting and supported systems.
  • Designed and implemented Extract, Transform and Load process (ETL) for Claims Data Mart.
  • Conducted technical session within team and present technical solution to Server Architecture, ETL and BI team
  • Develop ETL (SSIS) packages to import data from different file format and sources.
  • Created daily partitioning for extensively large tables and switch out/in processes to facilitate their ETL.
  • Manage application/ETL security, server roles, permissions and credentials.
  • Educate and troubleshoot any ETL issues raised by development teams.
  • Managed large complex data of ETL daily transaction volumes.
  • Manage all aspects of the SQL Server environment from the servers to the software, ETL, Reporting and data analytics.
  • Redesigned and migrated the data warehouse from Sybase IQ to SQL Server and converted all ETL to SSIS.
  • Experience in using Informatica (ETL Tool) for Data Extraction, Transformation and Loading.
  • Used Sagent Data Flow to perform ETL data extraction and reporting.
  • Developed ETL processes to the Orders datamart.
  • Support ETL Informatica, and Micro strategy.
  • Worked on ETL tools like Informatica and Cognos to provide the better picture of the business.
  • Maintained , designed and coded several WLM Stored procedures, Supported ETL tools (Informatica) Support release cycles.
  • Cleaned large datasets and prepared databases using Pentaho Kettle ETL tool for analytics.

Show More

5 ETL Jobs

No jobs at selected location

18. DB2

demand arrow
average Demand
Here's how DB2 is used in Senior Database Administrator jobs:
  • Designed and developed DB2 programs for Customers' Database Automatic Updating including maintenance of customer's account managers and account officers.
  • Work with application teams and organizational level teams in doing performance and tuning analysis work with DB2 applications.
  • Managed the Recovery 1 Network DB2 database with coding, standard formatting and automated standard reports.
  • Implemented db2 OPTIMIZATION PROFILE to improve the performance of the OLTP queries with parameter markers.
  • Configure replication from DB2 on mainframe to UDB on UNIX server using Data Propagator V8.
  • Perform the database administration task for the Firm's GWM division in DB2 Z/OS.
  • Enabled efficient development of new features by data refresh in DB2 using Export/Import/Load.
  • Mentored users in writing Complex DB2 UDB SQL Queries, as needed.
  • Establish, implement, and maintain recovery procedures for DB2 databases.
  • Upgrade DB2 from V6 to V7 in data sharing environment.
  • Provided 24x7 on-call support for DB2 databases.
  • Mentored Junior DB2 Database Administrator's.
  • Provide on-call production support for DB2/ZOS.
  • Worked as a backup DBA for DB2 UDB on Linux.
  • Open PMR's with IBM for any outstanding DB2 issues.
  • Joined the DB2 DBA team in early 2000.
  • Used ControlM to execute UNIX Korn shell scripts to accomplish scheduling of DB2 Database jobs in Production environment.
  • Resolved numerous live incidents related to DB2 while adhering to strict SLAs.
  • Developed Korn shell scripts to automate DB2 UDB Processes.
  • Provide technical ( DB2 ) support to internal developers Automated MVS Batch job processing.

Show More

8 DB2 Jobs

No jobs at selected location

19. Production Environment

demand arrow
average Demand
Here's how Production Environment is used in Senior Database Administrator jobs:
  • Involved in disaster recovery testing and high availability of production environments and prepare documents to client for future reference.
  • Provided 7X24support of several Oracle databases in a development and production environment.
  • Supported one production Oracle Business Intelligence environment and four non-production environments.
  • Developed and implemented database in test and production environments.
  • Participated in on-call pager rotation to support production environments.
  • Performed Redirected Restores from Production environment to PFIX environment.
  • Performed monthly database releases to production environments.
  • Worked on database release changes and supported migration of release changes from test environments to QA and Production environment.
  • Participated in the design and implementation of DBA request system, a change management system for non-production environments.
  • Customize the database for Development and Production environments, recommend defaults and monitor the databases.
  • Evaluated, documented PFT production environments, managed SQL Server Database and SQL Jobs.
  • Implemented database refresh solutions to QA and UAT databases from production environment.
  • Managed stored procedure migrations across test, QA and Production environments.
  • Provided System support for both development and 24*7 production environments.
  • Root Cause Analysis for Interruptions in Production Environments.
  • Migrated an Oracle 8i database with Veritas clustered production environment from one location to another with zero downtime.
  • Job responsibilities: Installation and configuration of RAC instances in 11g and 12cfor production environments.
  • Worked with Application Teams and Users to restore databases from production environment to Test/Dev/UAT environments.
  • Monitor sql agent jobs in our production environment.
  • Performed day to day GoldenGate activities Refresh production environment to QA/E2E/Test/Dev environment using RMAN backups and cold/hot backups.

Show More

5 Production Environment Jobs

No jobs at selected location

20. AIX

demand arrow
average Demand
Here's how AIX is used in Senior Database Administrator jobs:
  • Performed support for production IBM DB2 UDB v9.7 and v9.1 LUW (AIX) databases for Precision e-Care product.
  • Implemented Uni-directional Golden gate (12.1.2.1) source being on AIX and Target on Linux.
  • Perform the database administration tasks on UDB LUW at AIX and Windows platform.
  • Developed AIX Unix shell scripts to load Data Warehouse stage area.
  • Move included migration of system running on AIX to Linux systems.
  • Configured 10G database in a non RAC environment on IBM AIX.
  • Supported one 11i EBS Oracle Applications production AIX environment.
  • Converted twenty Oracle databases to AIX DB2 Databases.
  • Maintained as400 V6.1 and AIX V9.7 databases.
  • Refreshed schema and databases on AIX DB2 databases
  • Installed the new 12c OEM agent on the AIX 6.1 and RHEL 5 OS versions.
  • Install DB2 UDB on AIX.
  • Formulated and implemented a cross-platform Oracle9i database migration from AIX to Solaris for the NetOptimize application.
  • Install, configure, monitor, manage and trouble shoot Quest Foglight monitoring software version 4.7 for Oracle and AIX OS.
  • Worked on database builds including 10g, 11gR1 and 11gR2 versions on AIX 6.1, RHEL 5 and Sun Solaris environments.
  • Worked with Red Hat 4.0 environment, IBM AIX 5.3 Monitoring the alert logs and trace files regularly.
  • Worked on all flavors of Unix like Solaris, AIX, Linux.
  • Worked with Unix flavors like Solaris, AIX, Linux.
  • Worked on cross platform Oracle database migrations such as zLinux to AIX using transportable tablespaces and export/import utilities.
  • Install, configure, administer and secure Sybase 12.X and 15.X databases using Linux, AIX, and Solaris operating systems.

Show More

1 AIX Jobs

No jobs at selected location

21. OEM

demand arrow
average Demand
Here's how OEM is used in Senior Database Administrator jobs:
  • Implemented, configured and Monitoring, Alert and Problem Remediation Scripts via both the OEM and Oracle Management Server.
  • Experience in Administering Oracle Database 10g and 11g using Oracle Enterprise Manager (OEM).
  • Installed and configured Oracle Cloud Control 12c - OEM for monitoring all production database systems.
  • Implemented OEM 12c Repository database, OEM 12c Agent and golden gate plug-in Installations.
  • Configured and implemented Oracle Enterprise Manager (OEM) to monitor all databases.
  • Upgraded OEM Cloud Control 12c R1 to R3 along with target management agents.
  • Installed in Oracle 12C database and 12C OEM (Oracle Enterprise manager).
  • Experienced in working on 12c OEM for monitoring and setting up alerts.
  • Experience in Oracle OEM 12c implementation and operations in an enterprise scale.
  • Installed and configured Oracle 12c database and resource management using OEM.
  • Utilized OEM to start/stop database, backup/recovery, and performance monitoring.
  • Installed OEM SQL Server plug-in for monitoring SQL Server databases.
  • Installed and configured OEM 12c cloud control and OEM 10g.
  • Installed and Configured Enterprise manager OEM12C and 11g.
  • Created data Redaction Policy in Oracle 12c OEM.
  • Upgrade and Migrated 320 database targets from 10G OEM to 12c OEM.
  • Installed and configured Oracle 10g OEM and 11g OEM.
  • Installed and configure OEM, Weblogic software and Oracle Client on Application servers.
  • Monitor database and cluster using different shell script, OEM and Foglight.
  • Monitor Oracle 12c OEM console for supported databases performance optimization.

Show More

22. Grid

demand arrow
average Demand
Here's how Grid is used in Senior Database Administrator jobs:
  • Designed and implemented the company's Oracle Internet Directory (OID) and Grid Control using Oracle Application Server v10.
  • Developed Monitoring and Maintenance for a large platform of replicated Cluster Databases based on Oracle Grid Control.
  • Worked on Database and Grid patching activities for standalone and RAC 10g, 11g and 12C.
  • Worked with OEM grid repository and configured monitoring of all agents, databases and hosts.
  • Trouble shooting targets status on grid console/agent side and setting up blackouts for agents.
  • Utilized OEM Grid Control for performance monitoring alerts via notification rules and job scheduling.
  • Used Oracle 12c grid control and installed, configured and troubleshoot OEM agents.
  • Installed 10g/11g OEM agents and fixes, configured targets in grid.
  • Installed 12C grid control and registered Databases in OEM.
  • Managed instances using SRVCTL and 10g Grid control.
  • Installed and configured 10G Grid control enterprise manager.
  • Administered RAC databases using 10g Grid control.
  • Installed grid control agents on servers.
  • Used Oracle 10g grid, OID and LDAP.
  • Implemented Quest management tool suite Participated in Oracle GRID monitoring alerting setup and integration with Service Desk ticketing system.
  • Designed and configured Oracle Enterprise GRID Control [ ] to effectively manage, administer, and monitor entire database infrastructure.
  • Determine whether you have Exadata cell disk I/O bottlenecks on your storage grid.
  • Configured Sql Server databases performance monitoring through Oracle 10g OEM grid control.
  • Diagnose Exadata grid disk I/O bottlenecks on your Exadata storage grid.
  • Performed database tuning using the Advisor central (Segment Advisor, SQL Tuning Advisor, Memory Advisor) in Grid Control.

Show More

23. Sybase

demand arrow
average Demand
Here's how Sybase is used in Senior Database Administrator jobs:
  • Implemented SYBASE reliability and performance improvements and automated SYBASE processes, reducing process times 30%.
  • Administered SYBASE clients, servers, databases, and TSQL.
  • Trained peers on SYBASE technology.
  • Experience working with migrating oracle/Sybase ASE/MySQL databases across hosts.
  • Worked on Installation/setup/troubleshooting of Sybase Replication Server.
  • Lead SAP Sybase ASE and IQ Senior Database Administrator in 24 x 7 environments.
  • Worked on Warm standby and MSA replication setup and troubleshooting on Sybase ASE.
  • Worked on Logical Design and Data Modeling for Oracle and Sybase databases.
  • Install, and maintain Oracle, Sybase and SQL Sever 2005 databases.
  • Worked on Upgrades and Patching on Various Oracle and Sybase databases.
  • SAP Sybase ASE, Replication Server and IQ Training Instructor.
  • Supported firm wide Oracle and Sybase servers in production environment.
  • Worked on Installation/troubleshooting on Sybase ASE and IQ Database servers.
  • Migrated Sybase database from ASE 11.9.2 to ASE 12.5.
  • Installed and configured Sybase ASE servers.
  • Migrated Sybase database to Oracle.
  • Upgrade Oracle servers from version 8i to 9i and 10g Worked with Sybase and Oracle support team to resolve production issues.
  • Resolved issues with the migration of an undocumented legacy Sybase 12 database.
  • Installed and supported Sybase Adaptive and Sybase replication servers.
  • Provide DBA support on production and non-production Sybase ASE, Sybase RS & Sybase IQ.

Show More

3 Sybase Jobs

No jobs at selected location

24. On-Call

demand arrow
average Demand
Here's how On-Call is used in Senior Database Administrator jobs:
  • Experience supporting a mission-critical database environment with 24x7 On-Call Support including weekends.
  • Automated many daily duties and emergency procedures reducing daily on-call activities.
  • Provide on-call database production support.
  • Provided on-call support and worked on emergency requests from client and application team, besides coordinating with other support teams.
  • Provide on-call coverage for first response problem tickets for DBMS from Oracle, and patching on UNIX systems.
  • Provided on-call production database support eliminating 80% of alerts for the next on call DBA.
  • Involved in a 24/7 on-call rotation for supporting around more than 1000 production databases.
  • Provide dedicated 24 X 7 on-call support for SQL Server database environments.
  • Provided on-call support for Oracle and Microsoft SQL Server databases.
  • Experience as On-Call 24x7 production DBA support for Critical databases.
  • Involved in 24/7 on-call support for all the Oracle Instances.
  • Provided on-call 7X24 production support for most Oracle clients.
  • Provide 24 x 7 on-call support on rotation basis.
  • Participate in On-Call Rotation to support a 24X7 environment.
  • Provide on-call support for critical database system failures.
  • Provided 24/7 on-call support for production servers.
  • Team shares 24 x 7 on-call responsibilities.
  • Created appropriate metric alerts to be sent to on-call phones, emails and successfully integrated with Zabbix monitoring system via SNMP.
  • Provide DBA support for development and testing teams during software lifecycles as well as on-call production support for different clients.
  • Monitored windows/linux system using Solarwinds software Documented DB structures and functionalities Worked on 7X24 on-call

Show More

25. ASM

demand arrow
average Demand
Here's how ASM is used in Senior Database Administrator jobs:
  • Worked extensively on 11gr1 agent installation, configuring ASM, applying templates and addition and removal of databases from OEM.
  • Created tiered ASM disk groups by placing the higher-tier disk groups on the faster outer tracks of the disks.
  • Managed Oracle 10g databases using Automatic Storage Management (ASM) on the development domain.
  • Installed, configured and administered Automatic Storage Management (ASM) on RAC instances.
  • Configured Workload Management, ASM, RMAN for maximum performance in RAC environment.
  • Administrated Automatic Storage Management (ASM) on a Single Instance.
  • Installed standalone, two and four node RAC servers using ASM.
  • Configured and administered ASM on RAC based instances.
  • Migrated databases from file system to ASM.
  • Migrated databases from OCFS2 to ASM.
  • Installed and configured ASM instances.
  • Used ASM for database storage.
  • Installed Oracle 11g RAC using ASM and migrated 10g RAC database to 11g RAC.
  • Perform DASD Administration tasks using ASTEX, ISMF and CA-ASM2.
  • Upgraded the CRS, ASM and DB homes to 10.2.0.4.
  • Performed Stand Alone ASM and Software Only ASM (Oracle Restart) installs.
  • Configured EMC storage for asm disk groups.
  • Maintained ASM by adding disks and rebalancing.
  • Experience in optimizing ASM Diskgroups.
  • Sun Solaris, Linux, ASM, Oracle RAC 10G, 11G.

Show More

2 ASM Jobs

No jobs at selected location

26. QA

demand arrow
average Demand
Here's how QA is used in Senior Database Administrator jobs:
  • Installed, configured and migrated development, staging/QA, and production database instances across different environments.
  • Created Credit Data Validation (CDV), Staging, Reporting databases in development, SIT, QA, UAT environments.
  • Design and implement Priority Scheduler for workload management between the QA and PROD environments on the same system.
  • Provided Oracle Database Administrative support to SRS (Strategic Automation Initiative) developers, business analysts, QA.
  • Install and configure new SQL Servers in Development, QA (Quality Analysis), and Staging environments.
  • Worked closely with the development and QA teams to conduct codes reviews and assist with new releases.
  • Verified changes and facilitated Quality Assurance (QA) inspection support and product peer reviews.
  • Performed monthly refreshes of the development, staging and QA environments with production data.
  • Supported and monitored production, QA and development databases including versions 8i and 9i.
  • Worked with multiple Engineer teams, QA teams, completed numerous application projects.
  • Monitor application performance with DEV\QA application teams using load test, concurrency test.
  • Created DEV, QA and PFIX Instances and Databases using established ING procedures.
  • Worked closely with engineering and QA to improve SQL Server performance.
  • Installed and configured Oracle binaries in test, QA environments.
  • Supported Development and Development releases - QA and production.
  • Installed map releases in QA and production.
  • Designed and automated SQL server jobs to create schema backups of production schemas used to refresh the development and QA databases.
  • Provided technical support to developers and QA team for oracle and unix related questions.
  • Refreshed QA and Development databases using export/import, datapump and RMAN clone.
  • Performed all deployments and scheduled moves from dev/qa/stage to production by quality control checking and CR creation.

Show More

27. Ssrs

demand arrow
average Demand
Here's how Ssrs is used in Senior Database Administrator jobs:
  • Developed monitoring tool like performance Dashboards using SSRS tool for critical applications.
  • Authored all of Eagle SSRS reports for the DBA team to manage all aspects of the SQL Server environment.
  • Developed customer dashboard for meter-read metrics and reporting using SSRS * 2005 to 2008/2012 SQL Server upgrades.
  • Created and managed both the SSRS and SSAS infrastructure and authored reports and cubes which utilized it.
  • Developed SQL Server Reporting Services (SSRS) reports for end users to meet business requirements.
  • Generated reports from SSRS (SQL server reporting services) and SSAS.
  • Developed SQL reports with SQL Reporting Services (SSRS).
  • Develop reports using SSRS 2008R2 with Native and Integration mode.
  • Manage SSRS security for both corporate and client-facing reports.
  • Created drill down reports and sub reports using SSRS.
  • Administered an SSRS report server for the company.
  • Support SSRS, SSIS and database warehousing.
  • Configured SQL server and SSRS using IIS.
  • Managed SSRS and SSIS services.
  • Mentored developers on design of tables, queries, views, stored procedures, SSAS, SSIS, and SSRS.
  • Perform deployments for SQL Server, SSIS, SSAS, and SSRS objects.
  • Created XML, PDF, EXCEL files using SSRS.
  • Created parameterized reports, Drill down and Drill through reports using SSRS.
  • Worked on formatting SSRSreports using the Global variables and expressions.
  • Designed and implemented Parameterized and cascading parameterized reports using SSRS.

Show More

3 Ssrs Jobs

No jobs at selected location

28. Performance Issues

demand arrow
average Demand
Here's how Performance Issues is used in Senior Database Administrator jobs:
  • Identified and communicated trends and recurring performance issues and recommends potential solutions and developed resources approaches to optimize performance.
  • Supported the production environment by implementing recovery procedures, and monitoring the system for performance issues.
  • Investigated database and portal performance issues.
  • Worked extensively on performance issues.
  • Used the monitoring tool Spotlight to monitor, diagnose and resolve database performance issues for highly mission critical SQL instances.
  • Worked on performance issues, fixed row lock contention issues with huge inserts and tuned long running SQL queries.
  • Monitor databases and makes recommendation about performance issues with databases, PL/SQL code and queries and views.
  • Review application SQL code and advise application developer teams on best practices and performance issues.
  • Experience in troubleshooting database integrity issues, performance issues, blocking and deadlocking issues.
  • Worked closely with developers to fix the performance issues during production hours.
  • Identify, investigate, and resolve major system performance issues.
  • Worked on RMAN database cloning for performance issues.
  • Helped development team to resolve performance issues.
  • Assist developers in resolving performance issues.
  • Used AWR, ADDM, and ASH to diagnose performance issues.
  • Managed upgrades, replication configuration, migrated cluster services to latest version, tuned and resolved database performance issues.
  • Used SQL Profiler, Server side trace to identify performance issues on the server.
  • Worked on troubleshooting and performance issues on Sybase and Oracle databases.
  • Inspect Database Performance issues utilizing Splunk toolset and diagnostic scripts.
  • Configure RMAN for ASM in multi-nodes Analyzed and found the performance issues in E*file replication software.

Show More

29. Troubleshoot

demand arrow
average Demand
Here's how Troubleshoot is used in Senior Database Administrator jobs:
  • Scheduled, monitored, analyzed, troubleshooted all escalation production requests/issues.
  • Experience in problem analysis and troubleshooting database related issues.
  • Provided 24x7 technical support and troubleshooting for Federal Aviation Administration (FAA) mission critical databases and applications on UNIX platforms.
  • Installed, configured, troubleshooted and supported Oracle 11g and 12c RAC and Data Guard environments.
  • Work closely with Unix System Admins, Backup Admins, and Storage Admins on troubleshooting.
  • Experience in migration of applications from lower to higher versions and troubleshooting application's performance.
  • Performed support and maintenance tasks for EBS such as cloning, patching and troubleshooting.
  • Provided conflict resolution through analysis and troubleshooting of various issues in a support role.
  • Develop, Maintain, Troubleshoot data connectivity with SAP and Great Plains solutions.
  • Provided 24x7 on call production support to troubleshoot complex and sometimes cross-platform issues.
  • Perform and troubleshoot database backup, recovery, capacity, and security plans.
  • Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
  • Provided troubleshooting of network and server issues.
  • Configured and troubleshoot OEM agents.
  • Developed MySQL installation, configuration, troubleshooting, replication failover, and DR documentation.
  • Worked extensively with security requirements Troubleshooting analysis using Ignite and Red Gate
  • Design, maintain, and troubleshoot divergent, transactional replication streams across local and national data centers.
  • Supported the Datacenter migration activities, troubleshooting issues and Involved in RTP process.
  • Experience in Mysql server database troubleshooting.
  • Involved in on Exadata DB , Cell nodes and InfiniBand patching and troubleshooting issues.

Show More

2 Troubleshoot Jobs

No jobs at selected location

30. Toad

demand arrow
low Demand
Here's how Toad is used in Senior Database Administrator jobs:
  • Used third party vendor tools like Quest Central v 5.0, Toad, SPOT LIGHT for regular database administration.
  • Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
  • Used TOAD and BMC tools which include Catalog Manager, Change Manager, Main view etc.
  • Implemented dimensional model (logical and physical) in the existing architecture using Toad.
  • Participated in DBA on-call rotation using Oracle tools like OEM, RMAN and TOAD.
  • Monitored tables and check the performance of a database using TOAD 9.
  • Used TOAD, PL/SQL developer tools for faster application design and developments.
  • Used different modeling Tools: Erwin and TOAD for ERD generation.
  • Experience in using TOAD for SQL Development and DBA tasks.
  • Employed Toad and DBARTISAN for database administration and development.
  • Experience in Oracle EM/TOAD tool for monitoring the databases.
  • Used TOAD for various database Administration tasks.
  • Used TOAD DBA - SQL Optimizer to tune SQL and create indexes to improve SQL timing.
  • Used scripts OPM, Toad for DB2, Spotlight to monitor the databases.
  • Performed ETL process using SQL Loader, PL/SQL, Toad and SSIS.
  • Use OEM and Toad for Oracle to administer Oracle database systems Configure data guard for highly availability Oracle databases.
  • Design and document all database schemas using ErWin and Toad Data Modeler modeling tools.
  • Utilize the tools like Oracle Enterprise Manager, SQL Analyze and Oracle Expert, ERWin, Toad etc.
  • Used Oracle 11g OEM, Toad, Sql Developer, pgAdmin tool.
  • Worked with Oracle GUI tools like TOAD , Embarcadero , OEM.

Show More

31. R2

demand arrow
low Demand
Here's how R2 is used in Senior Database Administrator jobs:
  • Project Plan and Technical Delivery of all Microsoft Servers Upgrade including SQL Clusters to SQL Server 2008 and Windows 2008 R2.
  • Administered mixed SQL server environment, SQL 2000, 2005, 2008 R2 on a contract with the Department of State.
  • Administered a group of SQL servers (using SQL server 2008 R2) of the company in a clustering environment.
  • Used 11gR2 DB Control as well as Oracle 12c Cloud Control to monitor databases and database hosts.
  • Assisted in disaster recovery procedures and recovery using Data Guard in both 11gR2 and 10g.
  • Planned and implemented migrations from previous SQL Server versions to 2008 R2 and 2012.
  • Performed installation and administration of BusinessObjects (BO XI R2) using clusters.
  • Worked on migration of environment from SQL 2000/2005 to SQL 2008 R2.
  • Performed Installation, configuration, troubleshooting Oracle RAC Database in 11gR2.
  • Installed and maintained 4/6 node 11gR2 RAC database on Linux.
  • Performed database upgrades from 10gR2 to 11gR1.
  • Coordinated upgrades of databases from 2000, 2005, 2008r2 to 2012.
  • Upgraded 10g R2 to 11gR2 and applied patches.
  • Plan, Design, build and implement a new version for Darden Help Desk Application running on Cluster SQL 2008R2 SQL.
  • Experience in MS SQL Server 2008 R2 Created the backup schedule for production, test and development SQL Servers.
  • Migrated single instance 11gR2 databases to oracle 12c container with pluggable databases.
  • Worked on migrating data from 10G RAC to Exadata 11gr2 DB.
  • Created &configured Oracle 11gR2 databases with PeopleSoft environments.
  • Configured two node SQL 2008 R2 clustered server.
  • Installed numerous RAC databases typically 10gR2 / 11gR1 on 2 node Redhat Linux clusters utilizing NetApp NFS filesystems.

Show More

1 R2 Jobs

No jobs at selected location

32. Oltp

demand arrow
low Demand
Here's how Oltp is used in Senior Database Administrator jobs:
  • Developed and tested storage strategies and disaster-recovery plan for OLTP database, delivering solution that guaranteed recovery performance and high availability.
  • Configured the operational environment by determining best practices for data management and partitioning for OLTP, Query, and Archive compression.
  • Managed OLTP databases that provide the company's website, a financial portal with the information of South America countries.
  • Worked on Table partitioning feature of DB2 V9.7 version for OLTP environment and improved performance of the queries.
  • Provide SQL Server evaluation and recommendations for OLTP, Reporting, DR, and Data Warehouse environments.
  • Pulled data from OLTP Oracle Environment into SQL Server for ease of access using SSIS and SSAS.
  • Developed C# application to migrate data from OLTP production database to OLAP data warehouse.
  • Administered, monitored, and tuned this high performance 24X7 OLTP production Oracle web application.
  • Redesigned corporate structures from historic (30 year) designs into normalized OLTP design.
  • Performed data modeling, performance tuning, and optimization for OLTP and OLAP databases.
  • Manage production and development SQL Server database infrastructure (OLTP and OALP).
  • Provided 24x7 on-call support for OLTP database and disaster recovery support.
  • Developed and maintained small to very large OLTP and OLAP databases.
  • Configured and administered Oracle 10g Streams in replicating OLTP environments.
  • Replicated in OLTP as well as data warehouse environments.
  • Provide production support for critical databases, which consists the OLTP reservation platform and Market intelligence solutions.
  • Optimize database performance for OLTP and Data Warehouse environments on an Exadata Database Machine X3.
  • Managed OLTP and Datawarehousing Databases of almost 2 Terabytes in size.
  • Configured OLTP databases on Oracle Exadata platform using Exadata database machine X4-2Half Rack.
  • Manage Transactional Replication using GoldenGate (oracle) application to publish data on OLTP database to Query Server.

Show More

11 Oltp Jobs

No jobs at selected location

33. DTS

demand arrow
low Demand
Here's how DTS is used in Senior Database Administrator jobs:
  • Write code for accessing databases and creating stored procedures, executing and maintaining all SSRS and DTS/SSIS packages of the organization.
  • Create and troubleshoot ~200 DTS, data transformation services with Excel reporting using VB data scripting from SQL Server.
  • Developed and maintained stored procedures, DTS packages, views, and user defined functions for a SAP application.
  • Created and supported jobs under SQL Server for database backup/restore, DTS packages, and executing database commands.
  • Designed process to simulate patient data population for demo patients, using advanced TSQL and DTS.
  • Migrated data from various platforms to SQL Server using DTS, SSIS, and Red-Gate tools.
  • Designed, wrote and administered SSIS and DTS packages for data transfer and ETL processing.
  • Develop store procedures, triggers, DTS, and replication for all SOCCENT databases.
  • Created ETL process for, utilizing DTS and TSQL, clinical data warehouse population.
  • Migrated SQL Server 2000 to SQL Server 2005 and Converted DTS packages to SSIS.
  • Analyzed and streamlined DTS packages that integrates NTN's CRM and Financial databases.
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Leveraged DTS packages and SQL Loader routines to populate databases.
  • Created, tested and implemented DTS and SSIS packages.
  • Utilized SQL-Server DTS, Bulk Insert/Bulk Copy utility.
  • Converted DTS packages into SSIS packages.
  • Created and modified DTS packages.
  • Import & export data to and from SQL server with the use of the DTS tool.
  • Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS packages.
  • Designed new data models for GDTS System Management database and the Cargill IT Framework.

Show More

34. CPU

demand arrow
low Demand
Here's how CPU is used in Senior Database Administrator jobs:
  • Worked on locks, deadlocks, handling isolation level and concurrency effects, detect CPU, I/O, memory bottlenecks.
  • Resolved blocking and deadlocking issues, high CPU / memory, analyzed job timeouts, ETL load performance problems.
  • Monitored and reviewed Stats pack reports involving CPU, I/O Activity, memory and resource utilization.
  • Implement industry standard Security measures (User Security, CPU patching, DB Link optimization).
  • Involved in monitoring of server performance like checking up the CPU usage status and I/O status.
  • Apply all patch sets and CPU patches to Oracle software to avoid internal errors.
  • Test and implement Oracle security patches (CPU/PSU) for database & application.
  • Applied CPU patches each quarter to keep the databases up to date.
  • Apply Oracle database patches where required such as CPU and DST patches.
  • Upgrade databases and test/apply CPU/PSU as planned.
  • Applied quarterly CPU/PSU/ Stack(MLR17) patches.
  • Planned and implemented Oracle software installations 10g, upgrades to [ ] and one-off, CPU and other patches.
  • Performed implementation analysis for Capacity on Demand (COD), CPU limits and Resusage monitoring.
  • Implement Oracle Enterprise Management Database Control monitoring and Critical Patch Updates (CPUs).
  • Run topas to check current CPU utilization, Memory usage and paging space.
  • Tune system performance including OS tuning, Balance IO, Memory, CPUs.
  • Applied CPU (Critical patch update) using Opatch on Oracle 10g databases.
  • Monitor CPU, Memory, Paging space, Disk I/O and analyze those using topas, nmon and other tools.
  • Worked on capacity planning, reported disk and CPU usage growth reports using Teradata Manager, DBQL, and Resusage.
  • Applied various patches which includes quarterly CPUs/PSUs.

Show More

2 CPU Jobs

No jobs at selected location

35. T-Sql

demand arrow
low Demand
Here's how T-Sql is used in Senior Database Administrator jobs:
  • Develop T-SQL Scripts/Stored Procedures to Databases Administration and Routine Maintenance Tasks.
  • Created various complex T-SQL Queries, Stored Procedures, Views, Cursors and User Defined Functions to implement the business logic.
  • Used Erwin for physical data modeling and developed complex solutions using T-SQL (stored procedures, functions and views).
  • Optimized T-SQL(Queries and Procedures) by using the Execution plans(Estimated, Actual, Cache).
  • Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.
  • Improved database management and automation using PowerShell scripting, T-SQL, and 3rd party tools where necessary.
  • Designed packages, views, stored procedures, triggers and functions using PL/SQL and T-SQL.
  • Supported and helped users write the most sufficient T-SQL code, stored procedures and triggers.
  • Developed, modified and reviewed Stored Procedure, triggers, Shell Scripting, T-SQL Query.
  • Established fully functional monitoring setup using T-SQL / SQL Mail services / PowerShell scripts.
  • Assisted developers in writing the most sufficient T-SQL code, stored procedures and triggers.
  • Created complex Stored Procedures for T-SQL development and in SSRS.
  • Developed and maintained underlying SQL, T-SQL and PL/SQL code.
  • Provide database coding to support business applications using T-SQL.
  • Helped the application developers on writing T-SQL queries.
  • Design Jobs using T-SQL Store procedures and batch programs using a centralize Job engine to maintain 24/7 SQL database backups.
  • Supported the application development teams in optimizing tables, indexes, stored procedures, triggers, and ad-hoc T-SQL.
  • Converted legacy packages in DTS to SSIS 2008.Converted Active X scripts to T-SQL.
  • Migrate Sql server data to Oracle database using T-SQL and PL/SQL.
  • Developed and implemented database triggers, T-SQL and stored procedures within Oracle, SQL Server and Sybase.

Show More

36. SAN

demand arrow
low Demand
Here's how SAN is used in Senior Database Administrator jobs:
  • Managed IBC San Antonio's entire SQL Server 2005 farm which includes over 100 production servers and approximately 250 databases.
  • Project Description Nissan North America Inc is one of the leading automobile manufacturers having its IT headquarters at Nashville.
  • Automated SAN snapshots for DB refresh process, which were done within two minutes on nightly basis.
  • Manage 30+ QA and Development databases spread across Houston, San Antonio and Denver offices.
  • Implemented SAN to SAN volume replication between primary data center and Disaster Recover center.
  • Experience in NetApp SAN/NAS, EMC NAS/SAN storage configuration.
  • Involved in data modeling the tables in Cassandra.
  • Sole DBA responsible for Dealer Services Lead Management databases supporting thousands of dealers across the US and Canada.
  • Worked with infrastructure team on networking, SAN and VMware issues related to database performance.
  • Worked on internal POC for integration of Cassandra with Hadoop and HDFS.
  • Worked on NoSQL platforms such as MySQL, Mongo and Cassandra.
  • Install, setup, configure and manage Equallogic's SAN storage.
  • Experience with clustering on Hyper-VVMvare VMs and SAN management.
  • Involved in installing and configuring Weblogic Application Server 11g on RHEL 5 (Tikanga) and RHEL 6(Santiago).
  • Managed vendors for build out of datacenter including EMC storage, SAN Network, and Veritas clustering software.
  • Uncovered multiple storage and SAN mis-configurations by using combination of SQLIO, Perfmon, CrystalDiskMark, DiskSpd.
  • Managed EMC (CX3-40c) and Xyratex (FS5400E) SAN storages used by Oracle databases.
  • Upgraded both servers/applications to Sybase 15.7 on new hardware implementing new SAN storage and also introducing Sybase Partitioning and Sybase Replication.
  • Managed and maintained third party vendors tools like DBArtisan, BMC SmartDBA, Iwatch, and Autosys.
  • Created dScource, VDB , policies and snaps and sanpsync using DELPHIX Engine.

Show More

37. AWR

demand arrow
low Demand
Here's how AWR is used in Senior Database Administrator jobs:
  • Executed and provided ADDM, AWR and database health check reports to information owners and recommended solutions for improved performance.
  • Administered (11g RAC) environments adding and removing nodes to the cluster and handled performance tuning using AWR.
  • Well versed in reviewing AWR, ASH reports and 10046, 10053 trace files to identify potential performance problems.
  • Resolved many performance issues using AWR, ASH, SQL tracing and Oracle knowledge base.
  • Conducted database performance and tuning activities (includes fetching of AWR and ASH reports).
  • Monitor database performance (AWR) and tunes databases for optimized performance.
  • Used the AWR reports to tune the performance of database.
  • Document and test Oracle AWR difference report generation between baselines.
  • Worked on Performance Tuning of SQL using AWR Reports.
  • Automated Oracle performance data (AWR) save process.
  • Investigated and resolved RAC related performance bottlenecks using AWR/ASH.
  • Tuned production databases supporting the application using AWR.
  • Analyzed several processes using AWR reports.
  • Optimize Performance and Query tuning by using AWR, ADDR, STATSPACK, SQL ADVISOR, OEM and by setting profile.
  • Used AWR for the performance issues to analyze performance bottlenecks Setup and Monitoring of the Disaster Recovery Systems.
  • Tuned the WCRM application/database using Automatic Workload Repository (AWR) for real application cluster (RAC).
  • Tuned the databases for better performance using awr/ash reports, explain plans.
  • Tuned the RAC database for performance issues using AWR / Statspack reports.
  • Analyze the database with AWR/Statspack performance reports to fine tune the databases for optimal benefits.
  • Install agent through cloning.. Analyzing AWR report and tune the sql based on the requirement.

Show More

7 AWR Jobs

No jobs at selected location

38. Rdbms

demand arrow
low Demand
Here's how Rdbms is used in Senior Database Administrator jobs:
  • Implemented backup/recovery strategies to ensure RDBMS and application databases are available within an acceptable time frame after loss of production system.
  • Extended MySQL initiative to additional back-office databases and looking forward will migrate several Oracle databases to the MySQL RDBMS.
  • Provide senior-level support for multiple versions of Oracle RDBMS and guidance on implementing best practices for maintaining Oracle Databases.
  • Performed Oracle 11g/12c RDBMS installation, upgrade, configuration, backup, recovery, archiving & purging activities.
  • Developed interface programs in 4GL to extract DATA from Progress RDBMS to directly import into other databases.
  • Managed Verizon Cloud infrastructure database systems including Oracle RDBMS, MySQL, and MS SQL Server databases.
  • Functioned as systems architect for Boeing test pilots Flight Scheduling System (using Pervasive RDBMS).
  • Install new versions of the Oracle RDBMS and its tools and any other tools.
  • Coded a one-click deployment, trigger-based replication software for use against the Oracle RDBMS.
  • Supported multiple oracle RDBMS upgrades from 8i to 11G for Store replenishment systems.
  • Plan, install, configure and perform upgrades of Oracle RDBMS.
  • Performed several RDBMS upgrades from 9i to 10g.
  • Installed and configured Oracle 8/8i RDBMS.
  • Upgrade Oracle RDBMS server to 10.2.
  • Introduced high availability across the enterprise Created a consistent RDBMS strategy with identical jobs and maintenance routines.
  • Created secondary security process for Unidata RDBMS database.
  • Involved on EDI GENTRAN/Mentor, Oracle Application Server 4.08, Oracle RDBMS [ ] and Oracle Forms 4.5/6i implementation.
  • Worked in AWS (Amazon Cloud) to setup MSSQL and PostgreSQL RDBMS.
  • Installed/upgraded and configured oracle GoldenGate unidirectional table level / schema level between homogenous oracle to oracle rdbms replication.
  • Implemented Oracle 11g [ ] Cluster ware with 11g ASM [ ] for oracle 10g RDBMS database.

Show More

39. Perl

demand arrow
low Demand
Here's how Perl is used in Senior Database Administrator jobs:
  • Developed Perl coding standards for platform independence.
  • Created Perl/Shell scripts to monitor database systems
  • Tune EM Console 12c to properly maintain and be proactive in any issues for all Oracle Databases in Bonnier IT.
  • Developed Perl modules for GDTS administration scripts, which resulted in improved coding standards and faster development through code reuse.
  • Designed and Developed many scripts and tools in Shell/Perl/HTML to ease the day to day DBA tasks.
  • Developed and maintained shell/Perl scripts for setting up batch jobs for cleanup, maintenance and release scripts.
  • Developed data-scrubbing tools using Power Builder, C and PERL to clean database tables.
  • Create scripts using shell and PERL for scheduled administration, monitoring and reporting.
  • Ensured that databases were setup, configured, maintained and performing properly.
  • Run the hiring process and termination process properly.
  • Updated existing Perl script adding management of rotating tablespaces for partitioned tables.
  • Managed daily ETL processes using perl, PL/SQL and shell scripts to load data from OLTP to OLAP databases.
  • Deliver increased operational efficiency through automation using bash, perl, PHP, and Python.
  • Developed Perl scripts for database maintenance and data importation Ensure PC connectivity through ODBC.
  • Worked with Perl/DBI/mod_perl for database monitoring scripts.
  • Created solutions using various development tools including: SQL/Plus, Korn shell scripts, Perl programs, HTML, and cgi.
  • Develop DBperl, shell scripts to migrate data from SQL Server and Sybase databases to Oracle database.
  • Experience in configuration of automated report using perl and unix shell scripts.
  • Code Korn shell and perl scripts.
  • Create perl scripts to Reorg, Runstats and other maintenance tasks.

Show More

1 Perl Jobs

No jobs at selected location

40. Dataguard

demand arrow
low Demand
Here's how Dataguard is used in Senior Database Administrator jobs:
  • Created logical standby database from hot backup of primary database for DataGuard implementation.
  • Configured Physical Standby database using Oracle DATAGUARD for Disaster recovery.
  • Implemented Oracle Physical Standby DataGuard on multiple oracle 11g / 12c databases.
  • Maintained DR server and troubleshooting issues in DATAGUARD environment.
  • Installed RAC and configuring DataGuard.
  • Implemented RAC installations and configurations, database and tablespace restructure and redesign, normalization, partitioning, and compression and DataGuard.
  • Installed and Configured Logical and Physical Standby databases using Dataguard.
  • Configured disaster recovery sites for Oracle ERP & Normal Oracle databases (dataguard, physical standby database).
  • Build Disaster site for trading floor apps using Oracle DataGuard and Veritas Cluster, Replication, SRDF.
  • Utilized Physical Standby and Active Dataguard to offload reporting and provide HA for stand-alone database.
  • Designed and implemented system operation databases with Oracle RAC, Dataguard, and Grit Control.
  • Planned, built and supported large dataguard installations that support warehousing and data mining functions.
  • Implemented Oracle Physical Standby DataGuard 11gR2 on 2 Node RAC Cluster.
  • Performed database migrations using RMAN Duplicate as well as physical Dataguard.
  • Implement Oracle Dataguard for application databases running on Linux.
  • Created and managed Dataguard for Standby Databases.
  • Implemented Oracle Physical Standby DataGuard (10gR2, 11gR1 and 11gR2) on 3 Node RAC Cluster.
  • Project: Database Development and Management Administered 3 Oracle 9i databases running Dataguard to manage unexpected server problems.
  • Implemented Oracle 11g Acitve Dataguard environment as proof of concept to support reporting requirements.
  • Implemented Oracle 9i DataGuard for production failover & maintenance switchover.

Show More

41. Addm

demand arrow
low Demand
Here's how Addm is used in Senior Database Administrator jobs:
  • Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
  • Provided capacity planning and Emergency Performance tuning with ADDM, AWR and OEM trouble shooting for all kinds of issues.
  • Executed AWR, ASH and ADDM reports, analyzing the reports to fine tune the databases.
  • Tuned performance of 10g databases using Grid control, AWR, ASH and ADDM reports.
  • Stored procedures using PL/SQL and performance tuning using AWR, ASH and ADDM and OEM.
  • Performed database tuning using alert logs, AWR reports, ADDM, trace files.
  • Performed Troubleshooting of database using AWR and ADDM reports for 11g databases.
  • Involved in performance tuning of several applications using ADDM and AWR reports.
  • Generate AWR, ADDM, monitoring OEM for concurrency spikes etc.
  • Produced and analyzed AWR, ASH, and ADDM reports.
  • Generate and analyze AWR/ADDM for database performance diagnostic and review.
  • Used ADDM, AWR, EXPLAIN PLAN, TKPROF, and SQL * TRACE and WAIT INTERFACE for Performance Tuning.
  • Used RDA, ADDM, AWR and SQLTXPLAIN to improve the database performance.
  • Monitored database performance using AWR/ADDM reports and tuned the databases and associated applications based on SQL Tuning advisors.
  • Gathered, and administered AWR, ADDM, tkprof, alert logs and explain plan outputs.
  • Use execution plan, AWR, ADDM and various Oracle Advisors to tune databases.
  • Used AWR and ADDM reports to analyze and enhance the database performance.
  • Used EXPLAIN PLAN, TKPROF, SQLTRACE, ANALYZE, HINTS, AWR, ADDM, ASH, Statspack etc.
  • Monitor database and performance tuning with Oracle Statspack, AWR, ASH, ADDM, TOAD and OEM.
  • Used performance tools like sqlt, oswatcher, awr, addm, etc.

Show More

3 Addm Jobs

No jobs at selected location

42. Technical Support

demand arrow
low Demand
Here's how Technical Support is used in Senior Database Administrator jobs:
  • Planned and performed critical migration projects 9i-10g-11g involving coordination between end-users, business owners and various technical support groups.
  • Provide assistance with technical support to developers and analysts.
  • Provided technical support for various application development groups.
  • Provide day to day and on-call Oracle DBA technical support for application teams by monitoring database servers.
  • Offered praiseworthy technical support for a large end-user community of over 600 users spanning 7 districts.
  • Provide advanced technical support (3rd level) to customers and internal development and quality assurance.
  • Provide expert application/technical support for the users on DB2 databases with 33 partitions.
  • Provide technical support and mentor the group in mainframe and database technologies.
  • Evaluate new technologies, SME of database technologies and provide technical support.
  • Provide technical support to application developers on SQL coding and programming technique.
  • Develop and execute upgrade plans in conjunction with Technical Support staff.
  • Provided technical support and guidance to developers throughout the SDLC.
  • Provided DB2 object maintenance and technical support for CLASS project.
  • Maintained 24x7 technical support coverage, supporting field sales team.
  • Provided training and technical support for customers and peers.
  • Provided technical support and guidance to project teams.
  • People soft Administrator, DBA and Technical Support for HRMS 8.8, FIN 8.8 and FIN 8.0.
  • Served as primary technical support contact for a large international telecommunications customer (Rogers) in an Oracle RAC environment.
  • Provide 24x7 technical support of all the database and application activities in Dev, Test and Production.
  • Cash edge is providing technical support in merger of Wachovia bank into Well Forgo.

Show More

2 Technical Support Jobs

No jobs at selected location

43. TB

demand arrow
low Demand
Here's how TB is used in Senior Database Administrator jobs:
  • Worked with a team of 6 to manage over 2000 databases ranging from 350GB to 2.3TB.
  • Manage and administer small to large database instances ranging from 4GB to +4TB data sets.
  • Used RMAN to write database backup data directly to E10K tape drives going through NetBackup.
  • Supported over 200 databases across multiple platforms with sizes ranging from 500MB to 2TB.
  • Work with the backup team to configure and implement SQL Intelligent Policies via NetBackup.
  • Handled from 50GB to 1TB Size databases in both Stand-alone and Clustered environments.
  • Improved enterprise wide backup solution time and resource usage via RMAN and NetBackup.
  • Handled performance tuning and SQL Tuning for larger (2Tb+) databases.
  • Implemented partitioned view to replace 3 TB size partitioned table.
  • Converted 380 Oracle database backups from TSM/SQL Backtrack to NetBackup/RMAN.
  • Configure and build heartbeat monitoring in Golden Gate.
  • Total size of the Databases exceeds 3 TB.
  • Managed databases exceeding 5 TB in size.
  • Migrated more than 300 databases, more than 2 TB size from SQL 2000 to SQL 2005 and SQL 2008.
  • Support 4 TB 9i-11g four node RAC databases.
  • Architected and managed table partitioning for 200M row tables and .5TB databases.
  • Provide continuing support of over 100TB of data in Netezza.
  • Used Veritas NetBackup to perform backups to tape libraries.
  • Managed and extended Veritas Cluster/Veritas Netbackup Administration.
  • Monitored and maintained databases sizes ranging from 10 TBs to few hundred GBs.

Show More

44. Peoplesoft

demand arrow
low Demand
Here's how Peoplesoft is used in Senior Database Administrator jobs:
  • Installed & configured OSES (Oracle Secure Enterprise Search) on PeopleSoft 9.2 since it's a new search application.
  • Administer Oracle / SQL Server database of Lawson, PeopleSoft, Cash, and CRSO.
  • Handled the migration requests from the development and testing teams for all the PeopleSoft instances.
  • Maintained and supported PeopleSoft sandboxes for KPMG's HRMS and Financial 8.4 initiatives.
  • Backed up, Restore and cloned PeopleSoft Databases by using RMAN.
  • Installed and migrated PeopleSoft Upgrade applications to Oracle 12c from 11g.
  • Analyzed and reviewed PeopleSoft Environments based on the upgrade certified paths.
  • Configured Vertex (State Tax Software) for PeopleSoft FIN.
  • Take care of the Migration of data and PeopleSoft objects.
  • Upgrade path: PeopleSoft 9.0 to 9.2) Responsibilities:.
  • Managed PeopleSoft and DBA administration of 230 IBM Server/Blades.
  • Reviewed all audit reports of existing PeopleSoft PROD environments.
  • Supported PeopleSoft Application Versions 9.0/9.1.
  • Project: PeopleSoft DBA, Upgrade (PeopleSoft HCM 9.0 to 9.1) Responsibilities:.
  • Upgrade PeopleSoft - People Tools (HRMS) and Application (HRMS).
  • Designed and built a process to refresh non-production Peoplesoft databases using a SORT compare process and generated DSN1COPY jobs.
  • Installed & configured PeopleSoft 9.2 DEMO environments - People Tools [ ] and Application HCM 9.2.
  • Download Updates and Fixes and apply to the environments and maintain the customizations for the PeopleSoft.
  • Installed PeopleSoft applications - People Tools [ ] Application HCM 9.0/9.1,.
  • Upgrade PeopleSoft - People Tools 8.49.15 to [ ] (HRMS) and Application 9.2 (HRMS).

Show More

45. I/O

demand arrow
low Demand
Here's how I/O is used in Senior Database Administrator jobs:
  • Perform tuning I/O and memory, analyzing access plans, modifying SQL, stored procedures and provide support for application developers.
  • Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
  • Reviewed problematic and long running queries and suggested improvements based on disk I/O, memory usage and CPU utilization.
  • Configured the Oracle EXADATA server X2 for migration from legacy servers for enhanced improvements in hardware I/O performances.
  • Analyzed issues such as deadlocks, index utilization, and I/O, on SYBASE and UNIX resources.
  • Increased performance by eliminating contention factors like I/O, buffers, locks and latches in the database.
  • Resulted in decreased run times, I/O and DASD utilization and increased performance efficiency for online/batch systems.
  • Reduced overall DB2 subsystem I/O 60% by expanding and tuning buffers.
  • Monitor database growth, index fragmentation and minimize I/O bottlenecks.
  • Monitored network, I/O and disk performance.
  • Tuned indexes and reduced I/O bottlenecks.
  • Detect and resolve blocks, deadlocks, I/O wait time.
  • Designed and implemented Oracle 9i/Oracle10g data warehouse terabyte database under Solaris 8/64 bits.
  • Performed daily performance monitoring and tuning of: disk I/O, load balancing of tables/tablespaces, long running queries and sorts.
  • Collected Oracle stats, Cron on UNIX Kernel stats, check for swaps space, disk I/O, memory requirements.
  • Tuned database's parameters to improve performance and distributed datafiles to load balance disk I/O.
  • Improved the datamart batch processing from 8 hours to 5 hours and the disk I/O is reduced to 10 %.
  • Tuned parameters related to I/O throughputs such filesystem_io_options ect.
  • Monitored tablespace size, resizing tablespace, relocating data files for better disk I/O.
  • Changed bufferpool strategy from being application centric to I/O centric.

Show More

46. SOX

demand arrow
low Demand
Here's how SOX is used in Senior Database Administrator jobs:
  • Experience in implementing and maintaining database security and security database hardening for SOX compliant databases.
  • Maintain database operation environment with SOX compliance and adhere to corporate policy.
  • Implemented Disaster Recovery scenarios with SOX enabled features.
  • Provided Sarbanes-Oxley (SOX) compliance reports and enforced COI restrictions and scheduled regular external audits of corporate and production systems.
  • Implemented SOX project using Oracle Applications R12 (E-Business Suites) ERP in Boeing Spare parts project.
  • Support, deploy and audit servers to comply with SOX and PCI standards.
  • Worked with SOX component installation and generating SOX compliance report by OEM.
  • Led and Support SOX compliant databases for Compensation and Territory management systems.
  • Led and Support SOX compliant databases for Oracle ERP applications and databases.
  • Defined, documented and audited database standards for Sarbanes-Oxley (SOX).
  • Created quarterly automated processes to comply with SOX audit report requirements.
  • Support and implement all database changes for maintaining SOX compliance.
  • Established effective security processes plans and policies, like SOX.
  • Performed SOX compliant long term archival of business critical data.
  • Developed auditing and SOX Compliance scripts.
  • Supported audit requirements mandated by SOX.
  • Develop database standards as SLA and PCI, PII, SOX, and all complains for SQL Server and Oracle.
  • Experience with SOX auditing by maintaining regulations as per SOX compliances.
  • Prepare documents required by Sarbanes/Oxley Section 404 (SOX 404) legislation related to the Production IDMS Databases and any interfaces.
  • Provided support and mentoring to guide junior DBAs to meet their goals Audited project artifacts for SOX compliance.

Show More

47. Sharepoint

demand arrow
low Demand
Here's how Sharepoint is used in Senior Database Administrator jobs:
  • Documented critical business processes, created a disaster recovery plans, provided database and applications support; administrator for SharePoint environment.
  • Interacted with military and civilian personnel to analyze requirements, design, develop and support Web application and SharePoint.
  • Performed regular database monitoring and tuning supporting online applications and SharePoint 2007.
  • Participated in SharePoint implementation project.
  • Supported a large SharePoint environment.
  • Provided best solution using Always On for business critical applications which require 24hrs up-time like SharePoint, Office360, printing applications.
  • Created centralized web based reporting site using SSRS 2005 and integrated reports into NTN's SharePoint intranet.
  • Created Web Parts in SharePoint to access reports for the DB Central application.
  • Migrated contents of SharePoint 2010 site collections to new SharePoint 2013 environment.
  • Plan, design and implement SharePoint data protection, backup and recovery.
  • Installed and configured SQL server for a SharePoint 2010 deployment.
  • Developed and maintained SharePoint sites in 2007 and 2010.
  • Support the SQL databases in a SharePoint 2010 farm.
  • Develop dashboard using Performance point tool in SharePoint.
  • Manage and administer SharePoint 2010 farm.
  • Developed Web Parts for SharePoint.
  • Developed Sharepoint site for the DBA team to maintain inventory on database server information and change tracking on each database system.
  • Deployed reports in native mode and SharePoint portal and scheduled reports to run on daily basis to send e-mails.
  • Connected SQL Server to SharePoint and implemented Key Performance Indicators (KPIs) and dashboards.
  • Design, develop and deploy Sharepoint sites using Infopath, workflow, and Sharepoint Designer.

Show More

48. Olap

demand arrow
low Demand
Here's how Olap is used in Senior Database Administrator jobs:
  • Designed the logical and physical data model for Oracle Demand Planning, Oracle E Business in warehouse to store OLAP data.
  • Designed and built data marts that contain dimensional models (OLAP) sourced from the enterprise business data warehouse.
  • Analyze data and database changes, and provide performance tuning solutions for OutlookSoft's business intelligence OLAP installation.
  • Created Data Mart (using OLAP cubes) for historical tracking of packages for customer service reports.
  • Designed and developed a Decision Support System using OLAP and data warehousing data marts and Cubes.
  • Maintained and optimized existing OLAP cube aggregating more than 3 billions records of click data.
  • Assisted development team in logical schema design of new OLAP database for Data Mart.
  • Install, configure and maintain DB2 LUW DPF databases in support of OLAP applications.
  • Created stored procedures and SQL scripts in support of both OLTP and OLAP systems.
  • Designed triggers to identify data to be transferred from OLTP to OLAP systems.
  • Secure OLAP systems by limiting access to authorized users and protecting confidential data.
  • Set up of historical tables for an OLAP database using MSSQL 7.0.
  • Assist Business Intelligence support group troubleshooting OLAP cubes and SSIS packages.
  • Designed index structures in support of both OLTP and OLAP systems.
  • Set up Data Marts for OLAP systems.
  • Optimized and tuned OLTP and OLAP instances.
  • Administered and maintained OLTP and OLAP environments.
  • Implemented UNION ALL views for improving the OLAP queries.
  • Tracked and reported efforts on resolving level two support issues regarding Siebel and Oracle OLAP DB.
  • Evaluated and used various OLAP tools including Brio, Cognos and Informix MetaCube.

Show More

1 Olap Jobs

No jobs at selected location

49. BI

demand arrow
low Demand
Here's how BI is used in Senior Database Administrator jobs:
  • Plan and implement database maintenance plan for ensuring database reliability and integrity.
  • Re-installed Prod & non-prod architectures and improved the availability.
  • Improved Production availability from 75% to 99% after introducing Change Management as well as fixing configurations and redesigning architecture.
  • Manage Green plum environments (Big Data) for backups, data migration, access control, and re-balancing clusters.
  • Managed 60 SQL Servers, handled 80 databases, the biggest database I worked with was 500 GB.
  • Upgrade MySQL S/W - Oracle database installation, management and setup of standby databases for high availability.
  • Designed high availability solution on HP fault tolerant servers and Oracle 9i database as a service.
  • Monitored trends in disk space utilization, memory usage, and availability on key database servers.
  • Plan and upgrade SQL Server 2005 32 bit platform to SQL Server 2005 64bit platform installation.
  • Installed Oracle 9i software on all HP servers following oracle OFA recommendations for manageability.
  • Created multiple Oracle database instances on the high availability nodes to facilitate zero downtime.
  • Involved in DB2 migration from 32-bit server to 64-bit server process.
  • See above for detailed responsibilities.
  • Worked on upgrading 10g R2 RAC to 11g R2 RAC on Oracle Enterprise Linux 5 (64 bit) Platform.
  • Created application specific Real Application Cluster baselined performance and availability document for QA and end users.
  • Designed and developed high availability solutions for existing LIQUID application on NT using Oracle9i Real Application Cluster on Redhat ES 2.1.
  • Shell scripting (Korn) written for utility programs to enhance monitoring and administration capabilities.
  • Migrated single instance databases to multi-node 10g/11g RAC for high availability with ASM.
  • Value Adds to the Project Stabilize the Monitoring for a mission critical application.
  • Performed cross-hardware migration of Sybase ASE, with no or very little impact to availability, meeting the client SLA.

Show More

14 BI Jobs

No jobs at selected location

50. Vmware

demand arrow
low Demand
Here's how Vmware is used in Senior Database Administrator jobs:
  • Installed and configured Oracle 10g and ASM on HP-UX, Linux and VMware; implemented data files using ASM.
  • Manage virtual development environment using VMWare Workstation, provision Windows, UNIX and Linux virtual machines as needed.
  • Developed plan to virtualize test and staging environments contributing to an estimated 50% cost reduction using VMWARE.
  • Designed and implemented virtual systems using VMware to test new software and its effects on current systems.
  • Migrated all the Clustered SQL Server instances to Virtual Servers hosted on VMware ESX.
  • Manage and support SQL Server databases in a VMware environment.
  • Installed and administered Oracle RAC databases on VMware virtual clusters.
  • Hosted on Virtual Machines using VMware.
  • Install and administer VMware ESX 4, IBM WebSphere Process Server and Business Monitor 6.1 and 6.2, Informatica 8.6.1.
  • Define transactional limitations of systems now used by VMware as part of their press release information to the public.
  • Support VMware infrastructure, to better design database infrastructure which resides on VMware (internal cloud)
  • Set up and implemented multiple instances of Oracle 11g on VMWare Vsphere.
  • Deployed VMWare ESX 3.5 virtualization solution for development and production virtual servers.
  • Sun Solaris, Linux, Windows on VMware.
  • Managed Windows servers within VMware vSphere environment.
  • Install Oracle 10g, 11gR2 on VMWare vSphere 5 Enterprise, and migrate to ESX.
  • Designed and deployed 6 Vmware ESX4.0 Servers and vCenter 4.0 server using above EMC SAN storage subsystems for Datastores.
  • Maintain server data integrity through VMWare vSphere client Migrated MS ACCESS 2003 data to SQL Server 2008.
  • Used vCenter client to view/configure VMware resources and utilize vMotion to provide HA.
  • Worked closely with VMWare Administrator to plan and administer Virtualized Environments for SQL Server and Oracle built on VMWare Solutions.

Show More

Senior Database Administrator Jobs

NO RESULTS

Aw snap, no jobs found.

20 Most Common Skills For A Senior Database Administrator

Database

25.6%

Pl/Sql

11.9%

Recovery Procedures

9.1%

SQL

8.4%

DBA

6.8%

Windows XP

3.8%

High Availability

3.2%

Linux

3.1%

Unix

2.8%

Rman

2.8%

Capacity Planning

2.7%

Setup

2.7%

RAC

2.7%

Data Warehouse

2.3%

Ssis

2.2%

Solaris

2.2%

ETL

2.2%

DB2

2.0%

Production Environment

1.8%

AIX

1.8%
Show More

Typical Skill-Sets Required For A Senior Database Administrator

Rank Skill
1 Database 19.7%
2 Pl/Sql 9.2%
3 Recovery Procedures 7.0%
4 SQL 6.4%
5 DBA 5.2%
6 Windows XP 2.9%
7 High Availability 2.5%
8 Linux 2.4%
9 Unix 2.2%
10 Rman 2.1%
11 Capacity Planning 2.1%
12 Setup 2.0%
13 RAC 2.0%
14 Data Warehouse 1.8%
15 Ssis 1.7%
16 Solaris 1.7%
17 ETL 1.7%
18 DB2 1.5%
19 Production Environment 1.4%
20 AIX 1.4%
21 OEM 1.3%
22 Grid 1.2%
23 Sybase 1.2%
24 On-Call 1.2%
25 ASM 1.1%
26 QA 1.1%
27 Ssrs 1.0%
28 Performance Issues 1.0%
29 Troubleshoot 0.9%
30 Toad 0.9%
31 R2 0.9%
32 Oltp 0.9%
33 DTS 0.8%
34 CPU 0.8%
35 T-Sql 0.8%
36 SAN 0.8%
37 AWR 0.7%
38 Rdbms 0.6%
39 Perl 0.6%
40 Dataguard 0.6%
41 Addm 0.5%
42 Technical Support 0.5%
43 TB 0.5%
44 Peoplesoft 0.5%
45 I/O 0.5%
46 SOX 0.5%
47 Sharepoint 0.5%
48 Olap 0.5%
49 BI 0.4%
50 Vmware 0.4%
{[{skill.rank}]} {[{skill.name}]} {[{skill.percentageDisplay}]}%
Show More

9,371 Senior Database Administrator Jobs

Where do you want to work?

To get started, tell us where you'd like to work.
Sorry, we can't find that. Please try a different city or state.