Company DescriptionHello, 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 needsJob DescriptionRequirement details:Role : Sr Analyst, Applications SupportLocation : Atlanta, GA / Bothell, WADuration : ContractBGV 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 directionDefine and implement security best practices to secure, maintain and access archived dataReview application and database architecture to ensure data archiving solution is highly available and scalableMaintain catalogs of the data archivesPerform application upgrades to the data archiving software / OptimWork 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 appropriatelyPerform installation, configuration, troubleshooting, code optimization and capacity planning for application and database infrastructure to support application and data life cycle managementEstablish active archiving processes for production applications that wish to offload dataDevelop processes and procedures for requesting an archive solution. Assure that these processes and procedures tie into existing processes and procedures whenever possibleWork 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 dataReducing hardware, storage and maintenance costs by archiving historical data from applications and systems freeing valuable resourcesMaintaining optimal application performance levels by controlling ongoing database growthSet up security access for users requiring access to the archive data across multiple systemsResponding quickly to audit and discovery requests with universal access to archived informationCentrally managing and controlling archiving across applications, databases, operating systems and platformsGather & document detailed requirements of systems scheduled to be retiredDevelop data models for the archive databaseGain a thorough understanding of data contained in systems, so that relationships and logical connections can be made across archivesExecute the Data retirement processLead/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 requiredapplicationExperienced 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 applicationsFive to ten years as a database administrator working with SQL Server 2005 / 2008.Experience in a large, 24x7 environmentExperience with multi-terabyte databasesExperienced in Knowledge of Enterprise Archiving applications such as IBM Optim Infosphere Data Archiving Tool is a plusor similarExperienced in logical and physical data modeling to support application and data retirement/masking of various applicationsExperienced in Scripting and programming languages: Shell, VB Script, or similar and T-SQL, PL/SQL or similarExperienced 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 processesKnowledge of logical, physical transactional and dimensional database designKnowledge on Data architecture and data modeling support activities and toolsExperience with Veritas Storage Foundations productsExperience with telephony billing systems and related applications a big plusKnowledge of IBM Optim Data Archiving Tool is preferredExpert level knowledge of Unix/Oracle DB Administration experience in an enterprise environmentPrevious experience in an IBM-AIX, HP-UX and Sun Solaris Oracle environmentHigh 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 OEMSolid experience with the Unix operating system and command set as well as competence with shell scriptingThorough knowledge of physical and logical disk systems and their impact on database performanceExperience with server and database clustering techniques and the performance impacts thereofExpert 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 experienceThanks & Best RegardsSureshInfoWaysAdditional InformationAll your information will be kept confidential according to EEO guidelines.