Senior Database Administrator - Oracle and Microsoft

Integres, LLC is a Service-Disabled Veteran Owned Small Business (SDVOSB) which was established to provide high quality, insightful, agile information technology-based solutions to its customers. Integrity is a foundational element of everything we strive to do. We seek to develop solutions which respond to the evolving challenges that today’s organizations face using our own unique combination of industry best practices, and evolving techniques and technologies. We started Integres with the intent of building "a company with a soul". As such, we take a servant-leadership approach as the long-term strategy for our success. We are cultivating a corporate family culture which demands excellence and accountability while putting a premium on work/life balance. We empower and support our employees to contribute to achieving our corporate goals by interacting with our customers as true partners, rather than treating their engagement as just another job. We seek to be good corporate citizens and encourage and promote employee participation in community and volunteer work.

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.

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 Maryland State Comptroller's Office
• 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 DoIT 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 DoIT 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
• DoIT 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
Attachment A - Position Description – Role/ Statewide Agile Team Labor Category
Work Order Request #BPM043644-NN
Statewide Agile Resources and Teams 2024 – BPM043644 (all provisions apply)
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:
• DoIT Server and Storage Services team collaboration
• Vendor coordination and technical support management
• User training and issue resolution
• Cross-functional team leadership on technical initiatives

 

Education and Years of Experience:  Must possess a bachelor’s degree (master’s degree preferred).

Have at least five (5) years of practical experience as a senior DBA resource, including certifications as an Oracle and Microsoft SQL Database Administrator.

Preferred Skills:  The ideal candidate shall demonstrate the capability to independently furnish all necessary technical services required to successfully complete complex database administration tasks and produce high-quality deliverables across multiple enterprise systems. Candidates should possess comprehensive in-house expertise in Oracle and
SQL Server database administration, VMware virtualization, storage management, business intelligence platforms, and data center operations, or demonstrate established professional relationships and strategic partnerships with specialized technical resources to ensure seamless service delivery and support for all assigned responsibilities. 

Additional Requirements: Successful completion of a Fingerprint background investigation.

Min Citizenship Status Required: H 1B

Physical Requirements: None required for this position.

Location: 200 W Baltimore St. Baltimore, MD 21201. 

Integres offers competitive salaries bolstered by a comprehensive benefits package, which provides safety and security for our employees and their families. Our generous benefits package includes

• Healthcare and Insurance: medical, dental, vision, short- and long-term disability protection, basic life and AD&D insurance
• 401(k) Savings Plan
• Accrued Paid Time Off (PTO)
• Employee Recognition and Rewards
• Employee Referral Bonuses

Integres is an equal opportunity affirmative-action employer.  We encourage Minority/Female/Protected Veteran/Disabled applicants to apply.  Integres, LLC proactively fulfills its role as an equal opportunity employer.  We do not discriminate against any employee or applicant for employment because of race, color, sex, religion, age, sexual orientation, gender identity and expression, national origin, marital status, physical or mental disability, status as a Disabled Veteran, Recently Separated Veteran, Active Duty Wartime, or Campaign Badge Veteran, Armed Forces services Medal, or any other characteristic protected by law.

All your information will be kept confidential according to EEO guidelines.