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

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

• Contract

Hello,

I am Suresh from “Info-Ways” that is based out of NJ. Info-Ways helps major clients in the United States fulfil their technical staffing needs.

Requirement details:

• Role:
  Sr Analyst, Applications Support
• Location:
  
  Atlanta, GA / Bothell, WA
• Duration:
  Contract
• Background verification will be done for the selected candidates.

Please respond with your updated word resume and requested details:

• Full Name
• Work Authorization
• Contact Number
• Email
• Skype
• Current location
• Willing to relocate
• Expected Rate/hr
• Availability
• Best time to take interview

Feel free to contact me for any further information.

• Act as team lead to ensure responsible day‑to‑day database operations such as maintenance, monitoring, backup, and recovery are performed.
• Work with compliance and legal to determine data retention policies and execute retirement and define purge parameters.
• 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 catalog of data archives.
• Perform application upgrades to the data archiving software (Optim).
• Coordinate with cross‑functional teams to ensure backup processes, schedules, and retrieval of archived data are properly managed.
• Perform installation, configuration, troubleshooting, code optimization and capacity planning for application and database infrastructure.
• Establish active archiving processes for production applications that wish to offload data.
• Develop processes and procedures for requesting an archive solution, ensuring alignment with existing processes.
• Work closely with DBA, Development, Application Support and Governance teams to develop, test, and deploy data archiving solutions.
• Configure the archive system to handle additional data sources and relations.
• Reduce hardware, storage and maintenance costs by archiving historical data from applications and systems.
• Maintain optimal application performance by controlling ongoing database growth.
• Set up security access for users requiring archive data access across multiple systems.
• Respond quickly to audit and discovery requests with universal access to archived information.
• Centrally manage and control archiving across applications, databases, operating systems and platforms.
• Gather and document detailed requirements for systems scheduled to be retired.
• Develop data models for the archive database.
• Gain a thorough understanding of data in systems to identify relationships and logical connections across archives.
• Execute the data retirement process.
• Lead/coach junior DBAs in technology aspects (Oracle/SQL Server internals, RAC, RMAN, Grid Control, Data Guard).
• Monitor industry trends to identify potential opportunities for newer solutions in database archiving operations.
• Establish standards, policies and processes to leverage best practices in database team operations.
• 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.
• Provide expert knowledge on assigned applications.
• Guide Enterprise security team on defining best security policies and procedures for databases.
• Understand server clustering techniques and their impact on database configuration and performance.

• Five to ten years of experience in IBM‑AIX, HP‑UX and Sun Solaris environments, deploying and configuring Oracle Databases and Optim.
• Five to ten years as a database administrator working with Oracle and SQL Server, including Oracle RAC and Data Guard, to administer multi‑terabyte databases supporting high transaction 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.
• Experience in enterprise archiving applications such as IBM Optim Infosphere Data Archiving Tool.
• Experience in logical and physical data…