Senior Database Administrator Oracle and Microsoft at TechnoGen Inc

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 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 Key Skills Children Activity,Cost Accounting,Feed,Corporate Strategy,ERP Employment Type : Full Time Experience: years Vacancy: 1