Senior Database Administrator Oracle and Microsoft

Senior Database Administrator - Oracle and Microsoft

Senior Database Administrator / Systems Engineer to support critical data center operations. This role is essential to

maintaining our enterprise-grade infrastructure which includes comprehensive Oracle PostgreSQL IBM DB2 and Microsoft

SQL Server database administration across Production Development and Test environments. The successful candidate will

manage our complex virtualized environment consisting of 300 VMware virtual servers and physical rack-mounted systems

integrated with NetApp All Flash array and legacy EMC SAN storage solutions and will be a key participant in their migration

and refactoring in the AWS cloud. Key responsibilities encompass advanced IBM Cognos Business Intelligence administration

web services management and enterprise backup operations using CommVault Complete Data Protection platform and AWS

Backup utilities to perform for nightly server and database backups. This position requires expertise in maintaining high

availability multi-tier database environments while ensuring optimal performance security and disaster recovery capabilities

across all systems supporting the Maryland State Department of Educations educational data infrastructure. This role

demands a technical professional capable of managing complex enterprise systems in a mission-critical environment where

uptime and data integrity are paramount to supporting educational services across the state.

Duties and Responsibilities :

ORACLE DATABASE ADMINISTRATION

Core Functions :

Database installation configuration and version upgrades

Comprehensive tablespace and storage management

Database reorganization through export / import utilities

Schema management including tables indexes and partitions

Performance tuning including Oracle memory optimization

Rollback segment and extent management

Database backup recovery and restoration operations

Production-to-test database refreshes

Oracle CPU patching and RAC administration

Coordination with Oracle support for production hotfixes

Oracle Application Server & Portal Support :

Oracle 12c Application Server Portal administration

Regular database maintenance and logical backups

SQL

• Loader operations for payroll file processing

TAR management and Oracle consultant coordination

MICROSOFT SQL SERVER ADMINISTRATION

Core Functions :

SQL Server installation migration and platform upgrades

Database and user account creation and administration

Test environment provisioning for vendors and users

Backup monitoring recovery and restoration operations

Transaction log and data file growth monitoring

SQL Server Reporting Services administration

Database security management and consistency checks

Application vendor coordination and user issue resolution

BUSINESS INTELLIGENCE & REPORTING

IBM Cognos Environment :

Cognos Impromptu

Cognos Impromptu Web Reports

Cognos ReportNet

Administration Tasks :

Cognos catalog administration and user account management

Report creation modification and republishing.

Impromptu Web Reports troubleshooting and maintenance.

Directory Server administration and Access Manager integration

Distribution Shuttle Builder management

DATA INTEGRATION & ETL PROCESSES

Weekly file transfer coordination with Client

Financial Data Warehouse refresh verification and monitoring

Informatica PowerCenter & Designer troubleshooting (version 9.5)

Data transformation process management and error resolution

Annapolis Data Center (ADC) coordination for file transfer issues

Warrant data distribution to remote MSDE sites (WTC and DDS)

INFRASTRUCTURE & SYSTEMS ADMINISTRATION

Storage & SAN Management :

NetApp AFF-A300 SAN administration

Brocade FC 6510 and M5424 Switch configuration

LUN provisioning and datastore management

SAN capacity planning and OS upgrades

FC Zoning and Alias creation

VMware Environment :

VMware ESXi version 7 administration

vCenter management and troubleshooting

VM provisioning following client best practices

P2V conversions and server virtualization

vMotion and storage vMotion operations

VM snapshot management and VMware Update Manager

VMware Converter tool utilization

AWS Environment :

Provisioning following client best practices

Migration from VMware Environment to EC2 instances

Refactoring from EC2 instances to AWS RDS

Hardware & Network Support :

Cisco UCS chassis and blade server coordination

Support for Oracle RAC

Basic network administration and Windows server management

Server consolidation projects

Backup & Recovery :

CommVault Galaxy Simpana version 11 administration

Daily server database and VM image backup coordination

Client configuration troubleshooting

Database backup and restore operations

Client CommVault backup team coordination

WEB SERVICES & APPLICATION SUPPORT

Microsoft IIS Web Server 6.0 / 7.0 administration

Production website setup and maintenance

iPlanet Directory Server (LDAP) management

Application troubleshooting and user support

DocuShare upgrade management

Oracle WebLogic support

CRITICAL REQUIREMENTS

Security & Compliance :

Safeguarding of Personally Identifiable Information (PII) with highest security standards

Database security implementation and access control management

Regular security updates and patch management

Impact & Authority :

DBA recommendations and decisions affect all MSDE divisions

Considerable latitude in complex system administration

Enterprise-wide database strategy influence

Critical system uptime and performance responsibility

Coordination & Support :

Client Server and Storage Services team collaboration

Vendor coordination and technical support management

User training and issue resolution

Cross-functional team leadership on technical initiatives

Best Regards

Govinda rajulu. M Sr. Talent Acquisition Specialist

Key Skills

Children Activity,Cost Accounting,Feed,Corporate Strategy,ERP

Employment Type : Full Time

Experience : years

Vacancy : 1