- Database Services role provides planning, implementation, configuration, and administration of relational database management systems
- Monitoring data pipes/server performance, raising red flags if problematic jobs and informing users
- Identify problem users (in-efficient SAS programmers slowing down server performance)
- Scheduling jobs (night, day, weekend)
- Prioritizing jobs
- Traffic copping jobs
- Rationalize users
- Work with SAS Administrator on deploying best practice/efficient SAS program data processing jobs (data extracts/data integration)
- Implementing good database housekeeping rules so we can optimize our space and processing power
- Creates, administers, and controls database resources
- Monitors performance and tuning of the database, security/data protection, backup and restore, disaster recovery, capacity planning and data integrity
- Monitors performance, stress and load tests
- Works with project teams within the SDLC process ending with production acceptance
- Works with Architects and Data Modelers to continually improve on the alignment between the as architected, as designed, as built instantiation of data in database
- Leads the innovation and assessment of new and advanced database technologies, defining database references, technology roadmaps standards, policies, processes and best practices for implementations, upgrades, backups, security; and develops highly scalable database performance solutions and provides optimization methodologies by standardizing tools and processes that are used to solve both proactive and reactive performance issues
- Database Administrator - creates, administers and controls databases
- Maintains security, backup / restoration, and data integrity
- Monitors performance, stress, load tests, and tunes for increased performance
- Creates and refines standard processes and technical documentation to maintain accuracy and address gaps for future implementations
- Provides guidance and technical support for database-related issues which may involve working with in-house project teams, external contractors or solution providers
- Must be proficient in Teradata database technology
- Knowledge of SAS is a plus
- SAS Desired 1-3 Years Base/Entry
- PL/SQL Required 7+ Years Advanced
Please Include Job Title and Location in the Subject Line of Your Email
No comments:
Post a Comment