We are in the middle of the System Integration Tool upgrade project (SIT). The upgrade requires the use of an Oracle database for the backend.
POSITION SUMMARY: Under the direction of team managers, this position is responsible for the design,
implementation, management, and administration of enterprise database systems including the security,
quality, recoverability and integrity of data resources. This position provides both guidance to more junior
staff and input into database processes and standards and may have responsibility for user administration,
database configuration, backup and restore, disaster recovery, deployment, and capacity management
activities.
ESSENTIAL FUNCTIONS: THE FOLLOWING ARE THE USUAL, BASIC AND ESSENTIAL FUNCTIONS
OF THE POSITION. THESE FUNCTIONS ARE NOT TO BE CONSTRUED AS AN EXHAUSTIVE LIST OF
ALL RESPONSIBILITIES, DUTIES, AND SKILLS REQUIRED.
• Model ethical behavior and execute job responsibilities in accordance with Citizens core values, ethics, and
· information protection policies.
• Provide database administration for development and test databases, and physical relational databases
· including software installation, backup, recovery, data scrubbing, performance tuning, physical sizing and
· monitoring activities.
• Lead or participate actively in database requirements gatherings meetings and database review meetings.
• Recommend solutions by defining database physical structure and functional capabilities, database
· security, backup and recovery specifications.
• Lead efforts to monitor and tune databases to improve performance throughout the system development
· lifecycle, including but not limited to load tests simulating catastrophic event scenarios.
• Participate actively in the analysis and resolution of issues related to information flow and content with
· clients and IT management and staff.
• Facilitate data modeling studies in coordination with the Citizens' Architect and enforce enterprise data and
· database modeling standards.
• Install, configure, evaluate, and implement of DBMS software and database tools.
• Champion quality service delivery by enforcing and refining organizational standards.
• Define and document tasks related to Citizen's System Development Methodology (SDM) and contribute to
· the development of corporate data architecture standards and procedures.
• Automate scheduled database maintenance and reporting functions using industry best practices.
• Provide oversight and guidance to other database administrators.
REQUIRED KNOWLEDGE, SKILLS AND ABILITIES:
• Proven interpersonal, verbal and written communication skills, including technical documentation skills.
• Service-oriented, self-motivated, with keen attention to detail.
• Ability to manage multiple tasks, work in a collaborative team environment; be responsive to project and
• customer needs, and work under tight deadlines.
• Ability to work well within a cross-functional development team building relationships with developers,
• testers, and release managers in order to collaborate and deliver database services.
• Knowledge of database normalization data modeling techniques and experience with database design.
• Knowledge of Enterprise Systems Data Management and database best practices.
• Advanced knowledge of data manipulation and analysis tools such as Excel, Access, SQL, and SQL Stored
• Procedures (e.g., T-SQL, PL/SQL, and similar languages).
• Experience with Database Monitoring tools, Idera Diagnostic tools, IBM Control Center for DB2 and SQL
• Server Enterprise Manager, or similar tools.
• Experience in standard administration activities, such as Backup and Recovery, Security and
• Authentication, and Performance Tuning, Troubleshooting and Replication sql server.
• Strong knowledge of creating, executing and maintaining basic database batch processing tools such as
• Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) packages
REQUIRED EDUCATION AND EXPERIENCE:
• Bachelor's degree in Computer Science/ Information Technology or related field OR 6+ years of relevant
• experience OR a combination of college education and relevant work experience equivalent to 6 years.
AND
• 5 or more years of data system administration experience including running queries, generating statistics,
• analyzing data, and tuning and design;
• 5 or more years of experience using Windows Powershell to manage SQL Server and production support.
PREFERRED QUALIFICATIONS:
• Experience with SQL Server 2008 and 2012.
• Strong performance monitoring and tuning experience.
• SQL Server or DB2 certifications also a plus.
• Knowledge or experience in Property & Casualty Insurance industry.
PHYSICAL REQUIREMENTS:
• Requires the ability to sit for long periods of time, listen and converse over the telephone and frequently
Regards,
ShankarAsuvasoft201-603-9148
You received this message because you are subscribed to the Google Groups "SureShotJobs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sureshotjobs+unsubscribe@googlegroups.com.
To post to this group, send email to sureshotjobs@googlegroups.com.
Visit this group at https://groups.google.com/group/sureshotjobs.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment