What are the responsibilities and job description for the Oracle Sql Server Database Administrator position at Blossom Tech Solutions?
Oracle/SQL Server Database Management Specialist (Senior)
Location: Baltimore, MD
Duration: FullTime
Client: MDOT SHA
Minimum Certification Requirements
SEND PDF copy of Certificate
A. Oracle Certified Professional (OCP) Certification.
At least one of the following certifications:
A. Microsoft Certified Solutions Associate (MCSA): SQL Server 2012/2014
B. Microsoft Certified Solutions Associate (MCSA): SQL 2016 Database Administration
C. Microsoft Certified Solutions Associate (MCSA): Database Development
D. Microsoft Certified Solutions Associate (MCSA): BI Development
E. Microsoft Certified Solutions Associate (MCSA): Machine Learning
F. Microsoft Certified Solutions Associate (MCSA): BI Reporting
G. Microsoft Certified Solutions Associate (MCSA): Data Engineering with Azure
Minimum Experience Requirements:
- At least Six (6) years of experience in DBMS systems analysis and programming.
- Four (4) years of experience deploying software installations and upgrades for Oracle 11g / 12c Release 1 on a Windows OS environment.
- Four (4) years of experience deploying software installations and upgrades for Oracle 11g / 12c Release 1 on a Oracle Linux OS environment.
- Two (2) years of experience deploying software installations and upgrades for Oracle 19c / 12c Release 1 on a Windows OS environment.
- Two (2) years of experience deploying software installations and upgrades for Oracle 19c / 12c Release 1 on a Oracle Linux OS environment.
- Four (4) years of experience creating scripts for backing up data.
- Four (4) years of experience deploying applications that utilize Oracle Connection Manager.
- Four (4) years of experience configuring OEM tools and Oracle Grid Management Server.
- Four (4) years of experience creating database backups and recovery.
- Three (3) years of experience configuring RMAN for database backup and repository maintenance.
- Three (3) years of experience configuring SMTP.
- Four (4) years of experience deploying and configuring Oracle Data Guard on Windows OS.
- Three (3) years of experience configuring Quest TOAD DBA SUITE for Oracle.
- Three (3) years of experience configuring Quest SPOTLIGHT ON ORACLE RAC.
- Two (2) years of experience configuring data integration scripts with TALEND.
- Two (2) years of experience deploying and configuring Microsoft SQL Server 2016.
- One (1) year of experience deploying and configuring SQL Server Reporting Services (SSRS).
- At least three (3) years of experience in using current DBMS technologies, application design utilizing various database management systems and experience with DBMS internals.
- Must be capable of providing highly technical expertise and support in the use of DBMS. Must be able to evaluate and recommend available DBMS products to support validated user requirements. Defines file organization, indexing methods, and security procedures for specific user applications. Develops, implements, and maintains database back-up and recovery procedures for the processing environments, and ensures that data integrity, security, and recoverability are built into the DBMS applications.
- Respond to critical trouble reports encountered after regular business hours by Network On-Call Personnel.
- Respond to trouble reports or change requests (TR / CR Log) encountered by business users that are reported through Maximo Automated Help Desk Application.
- Provide technical expertise and advice to staff and management.
- Assist the Project Manager and Business Analyst in the preparation of documentation to describe new or changed processes.
- Conduct training of staff and/or end users, as needed.
- Attend organizational meetings as directed.
Primary Functional Responsibilities:
Server Configuration:
- Install database software and create the database.
- Determine and set sizing parameters for database structures.
- Strip data files across multiple physical/virtual devices and locations.
- Configure the database environment to support optimal data access performance.
- Create and manage database configuration files and table spaces.
- Create and manage multiple network configuration files.
- Configure the database instance to support shared server connections.
- Set up network tracing.
- Configure the network environment to allow connections to multiple databases.
- Ensure servers are current with SQL Server, Oracle and/or Windows security updates.
- Configure FTP, WSFTP and scripting to send and receive files.
Database Security Administration:
- Ensure servers are current with SQL Server, Oracle and Windows security updates.
- Analyze and evaluate the security procedures required for specific mission-critical business systems as defined by security standards/policies.
- Document various security procedures in place to provide system security. Provide access to this document only to authorized personnel.
- Define and Implement Security Policy.
- Configure Database Fine Grained Auditing.
- Use encryption toolkits to encrypt sensitive information.
- Configure RMAN encrypted backups.
- Set up Oracle Database, Listener & Connection Manager Security.
- Use Application Context for Authentication and Authorization.
- Configure LDAP and Active Directory Authentication using Enterprise User Security.
- Monitor and manage Audit Trail.
- Enforce security policies on database.
- Implement VPD (Virtual Private Database) and data masking strategies to hide sensitive data.
- Ensure Security Hardening at each level (OS/database/network).
- Check OS Event Logs, SQL Server Logs, Oracle Logs and Security Logs for unusual events.
Oracle Administration:
- Administer RAC
- Administer Data Guard
- Administer Enterprise Manager Grid Control
- Manage Database Availability and Recovery
- Administer Data Management
- Administer Performance Management
Microsoft SQL Server Administration:
- Ensure servers and databases are current with SQL Server patches and security updates.
- Administer SQL Server and SQL Clustering.
- Configure and monitor backups, restoration of databases.
- Set up Alerts for Backup jobs.
- Verify that all scheduled jobs are running successfully.
- Create and administer new databases and manage database users, roles and security.
- Monitor data and transaction log file growth.
- Resolve user issues and coordination with application vendors.
- Monitor OS Event Logs, SQL Server Logs, and Security Logs for unusual events.
- Create test SQL environment.
- Install, Configure & Upgrade SQL Server.
- Install SQL Server Service Packs (exp. SP2 and SP3).
- Monitor disk space, memory configuration and server performance using System Monitor, Profiler, DMVs (Dynamic Management Views), or the SQL Server 2008/2010 Performance tuning advisor.
- Use Management Studio or Profiler to help monitor and identify blocking issues.
- Create SQL Server alerts for notification of potential problems.
- Monitor MDF (Master Data File) and LDF (Log Data File) file growth and adjust if required.
- Configure database jobs.
- Set up and configure SQL Server Reporting Services.
TALEND Administration:
- Install, configure and setup of TALEND Enterprise Data Integration server.
- Install, configure and setup of TALEND Enterprise Data Integration Failover server.
- Establish Project Categorization
- Establish TALEND Project.
- Establish TALEND Job Design.
- Establish TALEND Metadata to be used / captured.
- Set up SVN (Server Virtual Name) Repository Configuration.
- Configure LDAP settings.
- Set up and configure SVN Backup procedures.
- Set up, configure and create data integration projects and jobs.
- Schedule data integration projects and jobs in TALEND scheduler.
Database Monitoring Tool Administration:
- Configure and use Spotlight tool to monitor the databases and TOAD, SQL developer for advanced coding.
- Provide data modeling using tools ERWIN and TOAD Data Modeler.
- Conduct load testing using tools like Swing Bench and TOAD Bench Mark Factory.
- Configure and use Oracle Total Recall and Oracle System Monitoring Plug-in for Microsoft SQL Server to enable history tracking and compliance auditing
New Technologies Investigation:
- Research, lab test, document and make recommendations to the TO Manager on a variety of new database related technologies that could be implemented and provide recommendations about the migration and upgrade paths for various systems.
- Coordinate the installation and implementation of database management system software and related software tools with contractors, other data processing staff and system users.
- Develop and implement new database management policies, procedures and standards
Please share update resume to praveen@blossomsolutions.net