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

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

Contract

Location:

Atlanta, GA / Bothell, WA

Duration:
Contract

• Act as team lead to ensure day‑to‑day database operations including maintenance, monitoring, backup and recovery are performed.
• Work with compliance and legal to determine data retention policies; 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 the data‑archiving solution is highly available and scalable.
• Maintain catalogs of the data archives.
• Perform application upgrades to the data archiving software (e.g., Optim).
• Coordinate with cross‑functional teams to ensure backup processes, schedules and retrieval of archived data are running appropriately.
• Perform installation, configuration, troubleshooting, code optimisation and capacity planning for application and database infrastructure to support data lifecycle management.
• Establish active archiving processes for production applications that wish to offload data.
• Develop processes and procedures for requesting an archive solution, ensuring they align with existing processes whenever possible.
• Work closely with DBA, Development, Application Support and Governance teams to develop, test, and deploy data archiving solutions across enterprise IT applications.
• Configure the archive system to handle additional data sources and their relationships to existing data.
• 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 across multiple systems.
• Respond quickly to audit and discovery requests with universal access to archived information.
• Centrally manage and control archiving across applications, databases, OS 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 to establish logical connections across archives.
• Execute the data retirement process.
• Lead/coach junior DBAs in technology aspects (e.g., Oracle/SQL Server internals, RAC, RMAN, Grid Control, Data Guard) to achieve team goals.
• Monitor industry trends and identify opportunities for newer database archive operations.
• Establish standards, policies and processes to leverage best practices for database teams.
• Participate in design and application review sessions, guiding development and architecture teams on 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 as a database administrator working with Oracle and SQL Server, including Oracle RAC and Data Guard.
• Experience with multi‑terabyte databases supporting highly transactional and data warehouse applications.
• Experience in a large, 24x7 environment.
• Knowledge of enterprise archiving applications such as IBM Optim Infosphere Data Archiving Tool or similar.
• Experience in logical and physical data modeling for application and data retirement/masking.
• Experience with scripting and programming languages:
  Shell, VB Script, or similar, and T‑SQL, PL/SQL, or similar.
• Experience writing, debugging, and tuning SQL/PLSQL code, SSIS packages, stored procedures, functions, triggers, etc.
• Knowledge of logical, physical transactional and dimensional database design.
• Knowledge of data architecture and data modeling support activities and tools.
• Experience with Veritas Storage Foundations products.
• Experience with telephony billing systems and related applications is a big plus.
• Expert level knowledge of Unix/Oracle DB administration in an enterprise environment.
• Experience in an IBM‑AIX, HP‑UX and Sun Solaris Oracle environment.
• High…