Job Seekers, Please send resumes to resumes@hireitpeople.com

Job Responsibilities:

• As a senior level information technology programmer/analyst, uses advanced principles and procedures of systems design methodology, structured systems design, and automated data processing techniques for new and existing complex computer applications.
• Research, draft and recommend database standards and policies.
• Coordinate with vendor support to address technical issues that could not be resolved in - house.
• Participate in the planning process to match emerging technologies with future business needs.
• Establish standards and guidelines for database space allocation based on best practices and implementation considerations based on business requirements.
• Calculate disk space requirements for existing and/or new installations and growth based on changing business requirements.
• Measure and/or forecast current capacity, gauge the growth of capacity over time, and factor in the anticipated capacity requirements to determine whether the existing infrastructure can sustain the anticipated workload.
• Research, analyze, and determine appropriate changes to DBMS parameters to support future application and database needs.
• Research, analyze, and determine appropriate hardware changes to support future application and database needs.
• Report recommendations to appropriate DBA specialist and/or technical services.
• Review results of database integrity checks.
• Resolve identified issues.
• Design appropriate strategy to reorganize database objects to release unused space or repair fragmentation.
• Install database management software in any environment Install database patches and service packs in any environment.
• Provide maintenance, support, and assistance to specialist DBAs with installation and configuration of clustered database failover, database replication solutions, and database backup solutions.
• Review, install, analyze, and implement security patches to be applied to remain Payment Cared Industry (PCI) compliant, vendor compliant, and Michigan Cyber Security compliant.
• Designs the security model based on set standards.
• Create database user accounts and schemas in production environments based on defined and approved forms and procedures.
• Define/design roles and profiles.
• Recommend standard password security policies.
• Implement data encryption.
• Design, configure, and initiate auditing with appropriate options as needed.
• Create and deploy new database in development and test environments.
• Ensures and validates the integrity and quality of the scripts to be promoted to any of the environments.
• Provide guidance to systems analysts, based on documented standards, in creating and modifying application specific database objects.
• Perform Data Export/Import/Load and data transformations between databases in production environments.
• Perform production data file transfers between different systems, across state agencies, federal government, vendors, etc.
• Analyze and resolve database space utilization in production environments.
• Analyze and resolve issues with database integrity in development, test, and production environments.
• Design and implement database backup solutions based on the business needs which include configuration, testing, implementation, modification, automation and monitoring of the backup and recovery solution as needed; troubleshoot and resolve more complex backup issues.
• Work with the Enterprise Backup and Recovery (EBUR) team to design and implement backup policy using available technology.
• Perform database restorations and point in time recovery to avoid data loss and meet service levels objectives.
• Perform troubleshooting of performance issues and provide required solution.
• Analyze databases for optimal performance and investigate poorly performing SQL statements and offending database sessions.
• Perform database performance tuning by identifying index candidates, updating database statistics, using appropriate optimization techniques, optimizer hints and other methods.
• Document tuning procedures.
• Perform thorough analysis and investigation to resolve locking conflicts. (For example: Locking conflicts can be shared or exclusive.
• Shared involve multiple users accessing the data or table at the same time.
• Exclusive is when only one user or process can access the data at a time.
• Locking conflicts can also be at different levels and an incorrect resolution can cause corruption or loss of data.)
• Analyze and resolve issues related to undo/redo/transaction log configuration and sizing in development, test, and production environments.
• Analyze and resolve server generated and threshold-based alerts.
• Perform resolution for the alert causes and provide recommendations for setting up appropriate alert thresholds.
• Implement defined initialization parameters, database instance memory structures and physical data layout for optimal performances.
• Monitor database jobs and scheduled processes, perform troubleshooting and provide resolution for any issues with jobs/processes as necessary.
• Document solution and provide root cause analysis.
• Agrees to follow all policy, standards, and procedures of DTMB.
• Database Storage and Capacity Planning: Monitor current space usage and contention.
• Perform capacity planning for future expansions of current application data and new applications needs.
• Calculate disk space requirements for existing and/or new installations and growth of complex databases (i.e., multiple databases, multiple servers).
• Recommend the procurement of new memory, CPUs, and servers when necessary.
• Research, analyze, and determine appropriate changes to RDBMS parameters to support future applications and database needs.
• Measuring current capacity, gauging the growth of capacity over time, and factoring in the anticipated capacity requirements to determine wither the existing infrastructure can sustain the anticipated workload.
• Database Security: Ensure that appropriate environment and database management system security settings are in place to prevent unauthorized access, loss, or damage to data.
• Authorize the establishment of database user accounts.
• Monitor, audit, and/or define roles.
• Monitor, audit, and/or define profiles.
• Ensure standard password security policies are followed
• Database Installation/Configuration: Install, configure, and upgrade the database software and security patches.
• Install database management software in any environment.
• Install database patches and service packs in any environment.
• Provide maintenance, support, and assistance to specialist DBAs with installation and configuration of clustered database failover.
• Provide maintenance, support, and assistance to specialist DBAs with installation and configuration of database replication solutions.
• Install and test patch updates for major installation, migrations, and upgrades.
• Communicate with database software vendors and DTMB technical staff to resolve any installation bugs or issues, satisfactorily and in a timely manner.
• Document all installation procedures and issues.
• Work with DTMB support staff on software issues that are relevant to database problems with the department.
• Other duties as assigned.

This position functions as a senior database & services administrator. In this capacity, the database administrator:

• Provides technical assistance to management in database server design and in database hardware/software standards.
• Provides technical assistance for database problems to network support staff, customer support staff, systems development staff, and all client staff.
• Responsible for overseeing the deployment and installation of database systems, maintenance, and resolving database server networking problems (with vendors, if necessary).
• Responsible for providing technical support when problems cannot be resolved by the client help desk and systems development staff. Occasional overtime may be required