Need 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 Responsibilities 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. Qualifications 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 skill with database commands and utilities such as exp, imp, sql loader, expdp, impdp, etc. Knowledge of Oracle memory structures, backup & recovery concepts, performance tuning, Grid Control, Data Guard, network concepts. Advanced knowledge of database administration tasks such as backups, recovery, tablespace additions, security. 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. Experience with database monitoring and tuning tools such as OEM. Solid experience with the Unix operating system, shell scripting. Knowledge of physical and logical disk systems and their impact on database performance. Experience with server and database clustering techniques and their performance impacts. Expert knowledge of SQL Server 2005/2008. Advanced knowledge of debugging and performance tuning of stored procedures, UDFs, triggers. Advanced knowledge of index analysis, data normalization, and advanced installation/configuration procedures. Advanced knowledge of hardware, including RAID and multi‑processor architecture. Advanced knowledge of VBScript and advanced DTS/SSIS package design. Advanced knowledge of networking related to SQL Server connectivity. Advanced knowledge of shell scripting (command line applications, batch files). Minimum Education and Experience Requirements Four‑year degree in Computer Science, Engineering, or Information Technology and five years of experience; OR Master’s degree in the same fields and three years of experience. All your information will be kept confidential according to EEO guidelines. #J-18808-Ljbffr Infoways