Senior Database Administrator - Oracle and Microsoft

Overview

On Site
Accepts corp to corp applications
Contract - W2
Contract - Long Term

Skills

ORACLE
SQL

Job Details

TECHNOGEN, Inc. is a Proven Leader in providing full IT Services, Software Development and Solutions for 15 years.

TECHNOGEN is a Small & Woman Owned Minority Business with GSA Advantage Certification. We have offices in VA; MD & Offshore development centers in India. We have successfully executed 100+ projects for clients ranging from small business and non-profits to Fortune 50 companies and federal, state and local agencies.


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 Education's 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
R*Stars Data Refresh Administration:
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

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.