DBA

Job Description

• 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 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.
• Review, install, analyze and implement security patches to be applied to remain PCI compliant, vendor compliant, and OES 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.
• Define/design profiles.
• Recommend standard password security policies.
• Implement data encryption (13+design 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.
• 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.
• 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.
• 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.

Required Experience:

• 7+ years of Database administration
• SQL and Sybase experience
• Strong experience in HA and DR solutions.
• Transparent Data Encryption within SQL Server.
• Over 3+ years of experience creating, updating and maintaining systems documentation.
• Unix, Solaris and Red Hat Linux experience
• A bachelor’s degree (highly preferred)