Need Sr Analyst, Applications Support at Atlanta, GA / Bothell, WA

Requirement details

Role

Sr Analyst, Applications Support

Location

Atlanta, GA / Bothell, WA

Duration

Contract

BGV will be done for the selected candidates.

Please respond with your updated word resume and requested details:

Full Name

Work Authorization

Contact Number

Email ID

Skype ID

Current location

Willing to relocate

Expected Rate/hr

Availability

Best time to take interview

Feel free to contact me for any further information.

Job Description

Responsibilities

Act as team lead to make sure Responsible for the day to day database operations like including maintenance, monitoring, backup and recovery are done.

Work with compliance and legal to determine data retention policies and requirements; execute retirement and define purge parameters under their direction

Define and implement security best practices to secure, maintain and access archived data

Review application and database architecture to ensure data archiving solution is highly available and scalable

Maintain catalogs of the data archives

Perform application upgrades to the data archiving software / Optim

Work with management teams to determine Coordinate with cross-functional teams to ensure processes running backups, appropriate back up schedules archiving and retrieval of archived data and set up, schedule and ensure that backups of the archived data are are occurring appropriately

Perform installation, configuration, troubleshooting, code optimization and capacity planning for application and database infrastructure to support application and data life cycle management

Establish active archiving processes for production applications that wish to offload data

Develop processes and procedures for requesting an archive solution. Assure that these processes and procedures tie into existing processes and procedures whenever possible

Work closely with DBA, Development, Application Support and Governance Teams in developing, testing, deploying data archiving solutions across the enterprise IT applications.

Configure the archive system to handle additional data sources and how they relate to existing data

Reducing hardware, storage and maintenance costs by archiving historical data from applications and systems freeing valuable resources

Maintaining optimal application performance levels by controlling ongoing database growth

Set up security access for users requiring access to the archive data across multiple systems

Responding quickly to audit and discovery requests with universal access to archived information

Centrally managing and controlling archiving across applications, databases, operating systems and platforms

Gather & document detailed requirements of systems scheduled to be retired

Develop data models for the archive database

Gain a thorough understanding of data contained in systems, so that relationships and logical connections can be made across archives

Execute the Data retirement process

Lead/Coach Junior DBAs in technology aspect(ex. Oracle / SQL Server internals, RAC, RMAN, Grid Control and Data Guard) to achieve team goals.

Monitor industry trends identifying potential opportunities for newer opportunities in database archive operation.

Establish standards, policies and processes to leverage best practices in the operation of the database teams.

Participate in design and application review sessions, guide development and architecture teams on delivering highly available and scalable solutions.

Guide team members on troubleshooting shell scripts, SQL and PL/SQL scripts.

Expert in Oracle / SQL Server Database Administration, installation/migration, backup/recovery, high availability, disaster recovery, performance tuning, trouble shooting, code optimization, capacity planning.

Provide expert knowledge on the assigned applications.

Guide Enterprise security team on defining best security policies and procedures for the databases.

Understand server clustering techniques and the impact on database configuration and performance.

Minimal functional and technical requirements

Five to ten years in an Experienced in IBM-AIX, HP-UX and Sun Solaris environment to deploy and configure Oracle Databases and Optim requiredapplication

Experienced Five to ten years as a database administrator working with Oracle and SQL Server including Oracle RAC and Data Guard to administer and maintain multi-terabyte databases supporting Highly Transactional and Data Warehouse applications

Five to ten years as a database administrator working with SQL Server 2005 / 2008.

Experience in a large, 24x7 environment

Experience with multi-terabyte databases

Experienced in Knowledge of Enterprise Archiving applications such as IBM Optim Infosphere Data Archiving Tool is a plusor similar

Experienced in logical and physical data modeling to support application and data retirement/masking of various applications

Experienced in Scripting and programming languages

Shell, VB Script, or similar and T-SQL, PL/SQL or similar

Experienced in writing, debugging and tuning SQL and PL/SQL codes, SSIS Packages, Stored procedure, functions, triggers etc. to troubleshoot issues related to databases or archiving processes

Knowledge of logical, physical transactional and dimensional database design

Knowledge on Data architecture and data modeling support activities and tools

Experience with Veritas Storage Foundations products

Experience with telephony billing systems and related applications a big plus

Knowledge of IBM Optim Data Archiving Tool is preferred

Expert level knowledge of Unix/Oracle DB Administration experience in an enterprise environment

Previous experience in an IBM-AIX, HP-UX and Sun Solaris Oracle environment

High degree of skill with database commands and utilities such as exp, imp, sql loader, expdp, impdp, etc.

Very good knowledge on Oracle memory structures, Backup & recovery Concepts, Performance Tuning, Grid Control, Data Guard and Oracle Network Concepts.

Advanced knowledge of database administration tasks such as backups, database recovery, TTS, tablespace additions, security, etc.

Advanced installation and configuration experience. Strong knowledge of RAC and Data Guard setup.

Ability to write, debug and tune sql and pl/sql, packages, procedures, functions, triggers, etc.

Experience with database monitoring and tuning tools such as OEM

Solid experience with the Unix operating system and command set as well as competence with shell scripting

Thorough knowledge of physical and logical disk systems and their impact on database performance

Experience with server and database clustering techniques and the performance impacts thereof

Expert level knowledge of database technologies on SQL Server 2005 / 2008.

Advanced knowledge of debugging and performance tuning stored procedures, UDFs and triggers.

Advanced knowledge of index analysis.

Advanced knowledge of data normalization.

Advanced knowledge of various monitoring and tuning tools such as Profiler, Quest Spotlight, LiteSpeed, SQL Performance Analyzer.

Advanced knowledge of advanced installation and configuration procedures.

Advanced knowledge of hardware, including RAID, multi-processor architecture, etc.

Advanced knowledge of VBScript and advanced DTS, SSIS package design.

Advanced knowledge of networking and how it relates to SQL Server connectivity.

Advanced knowledge of shell scripting (i.e. command line applications, batch files, etc.)

Minimum Education and Experience Requirements

A Four year degree in Computer Science , Engineering or Information Tech Discipline and 5 years of experience OR Master’s Degree in Computer Science , Engineering or Information Tech Discipline and 3 years of experience

Thanks & Best Regards

Suresh

InfoWays

All your information will be kept confidential according to EEO guidelines.