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

Role

• Sr Analyst, Applications Support
• Location: Atlanta, GA / Bothell, WA
• Duration: Contract

BGV will be done for the selected candidates.

Availability

Best time to take interview: Feel free to contact me for any further information.

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

Additional Information

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