Hello, 

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.