Georgia Employer LEAD SYSTEMS CONSULTANT in Atlanta, Georgia

Lead Systems Consultant needed by Verizon in Atlanta, GA DUTIES: Support the production database related issues, including troubleshooting and debugging complex data issues, querying data, creating stored procedure, and providing production/release support. Perform SQL and PLSQL database development and design, including triggers, packages, functions, procedures, object types, materialized views, and partitioning for production support needs. Provide troubleshooting and issue resolution support for a production database using SQL code development and Unix and Linux operating systems. Work on Unix and Linux shell scripting. Use SQL to diagnose issues generated from customers through a ticketing system, and provide solutions to customers. Work with the team to solve all issues sent through the ticketing system from customers. Work with reporting and billing databases in a high transaction (50,000+ transactions per day) environment. Run monthly billing process to generate invoices for customers, and use SQL coding skills to resolve any issues reported by the finance team during the monthly billing process. Provide on call support and respond to issues raised through the Pager Duty system, including logging into a Linux server, checking running processes, logs, and general health of the server, and determining if a restart of any application is necessary to maintain business functions. Analyze and resolve any other technical issues that arise through the Pager Duty system. Innovate ways to automate any repetitive processes, identify any opportunity to automate a process to reduce man hours and/or improve precision, and develop solutions to meet these needs. Develop design documentation, when necessary, and perform code reviews. Support internal and external customers, and work with Java development teams on their use of the databases. REQUIREMENTS: Bachelor's or foreign equivalent degree in Computer Science, Computer Engineering, Electrical Engineering or a related field followed by 4 years of experience performing SQL and PLSQL database development and design, including triggers, packages, functions, procedures, object types, materialized views, and partitioning for production support needs. 4 years of experience working with reporting and billing databases. Experience therein to include 3 years of experience providing production/release support. Experience therein to include 1 year of experience working with Unix and Linux shell scripting. To apply, mail resume to Matthew Schaefer, Tech Manager-System Anly. & Prg., Verizon, 2002 Summit Blvd, Atlanta, GA 30319. Please refer to Job #GADA1-S