Hi,
*Please send your resume to divy...@idctechnologies.com <su...@idctechnologies.com>* *Location: Lexington, MA* *PRINCIPAL RESPONSIBILITIES AND DUTIES**:* · Responsible for administration, maintenance and availability of Netezza and Oracle databases. · Ensure backup and recoverability of all databases. · Troubleshoot performance issues, identify bottlenecks, and recommend solutions at the server level, database level, and SQL level. · Define and configure appropriate level of monitoring and alerting. · Work with database vendor as needed, to drive solutions to various bugs, performance issues, outages · Work collaboratively with architects to identify, troubleshoot, review and resolve performance issues · Manage security by configuring users, groups and permissions · Ensure data security. Define and implement database access control policies and procedures, complying with SOX and HIPAA requirements. · Works with Data Architect on long term strategy to ensure integrated database systems. Advise on physical data model and implement changes. · Responsible for capacity planning, working closely with Infrastructure group to allocate appropriate database resources on servers. · Contribute to the ongoing development of technology and production processes company-wide. Keep abreast of new design tools, hardware, software, and technology and make recommendations for future deployment. · Provide technical leadership. Mentor junior DBA’s on the team on database technical details. Provide technical assistance to developers. · Create and maintain quality control and auditing of databases. · Develop and adhere to common database standards and procedures within a production operations unit. Maintain documentation related to database platforms, guidelines, methods and standards. · Coordinate with technical project managers, developers and other team members to coordinate database requirements across projects. · Triage/track outstanding issues, providing solutions to resolve defects and issues. · Develop and adhere to common database standards and procedures within a production operations unit. Maintain documentation related to database platforms, guidelines, methods and standards. · Interact with business users verifying or helping to verify data integrity. · Administer, maintain and support QA and development environments. · Responsible for administration, analysis, design, and creation of new databases. · Document and improve existing processes related to operations and daily work. · Other duties as assigned *EDUCATION**:* Bachelor’s degree in MIS, Computer Science or related field required or equivalent experience in lieu of. *EXPERIENCE AND REQUIRED SKILLS**:* · 8+ years of experience in IT · 6+ years of DBA experience including 3+ years with Netezza, and 3+ years with Oracle · Strong problem solving skills in virtualized database environments · Ability to be proactive and work well under pressure, multi-task · Must have shell scripting experience *Oracle DBA skills:* · Installation, configuration, maintenance and performance tuning of Oracle database · Demonstrated ability using database monitoring tools, including OEM, ADDM and AWR. · Experienced with Data Pump, SQL Loader, RMAN, PL/SQL, and Unix shell scripting · Oracle certification is a plus *Netezza DBA skills:* · Must possess a solid background in Business Intelligence and Data Warehousing · Must have experience in large multi-terabyte DW environments · Excellent knowledge of Netezza Architecture and system internals · Experience analyzing query execution plans, optimize query performances, and tuning Netezza appliances · Demonstrated ability defining administrative and operational standard practices using Netezza utilities such as Groom, Distribution, statistics, Zone Maps, etc… · Experience using Materialized Views , CBTs , External Table · Experience with utilities such as NZSQL, NZ_MIGRATE, NZLOAD, NZBACKUP, NZRESTORE · Experience with GRA and WLM configuration *Regards,* *Darshan IDC Technologies, Inc * *1851 McCarthy Boulevard, Suite 116, Milpitas, CA, USA, 95035.* *Phone No. :- (*408) 882-6837 *Mailto :- divy...@idctechnologies.com <su...@idctechnologies.com>* -- You received this message because you are subscribed to the Google Groups "CorptoCorp" group. To unsubscribe from this group and stop receiving emails from it, send an email to corptocorp+unsubscr...@googlegroups.com. To post to this group, send email to corptocorp@googlegroups.com. Visit this group at http://groups.google.com/group/corptocorp. For more options, visit https://groups.google.com/d/optout.
