James Sergent

James Sergent Email and Phone Number

Architect 2 and Senior Oracle Application DBA @ Bank of America
North East, MD, US
James Sergent's Location
North East, Maryland, United States, United States
About James Sergent

Information Technology Professional with 23 years hands-on experience as an Oracle PL/SQL Developer and an Oracle Application / Development Database Administrator.As an Oracle PL/SQL Developer, have extensive experience developing packages, procedures, and functions for both OLTP and data warehousing projects with emphasis on ETL using either custom Oracle Processes as well as utilizing 3rd party tools like Informatica and Autosys. As a lead Oracle PL/SQL Developer, mentored junior developers, which included code reviews. As an Oracle Application / Development Database Administrator, coordinated with application teams to create and maintain Oracle Objects like tables, triggers, views, sequences, materialized views, external tables, and database links. Reviewed SQL for performance issues. Planned and executed database deployments in all levels, from development all the way to production. Coordinated with production support DBA’s with creation and maintenance of Oracle Databases which included storage and backup and recovery. As a lead Oracle Application DBA, mentored junior DBA’s, which included software deployments as well as providing support to application teams, business analysts and management teams.

James Sergent's Current Company Details
Bank of America

Bank Of America

View
Architect 2 and Senior Oracle Application DBA
North East, MD, US
Employees:
232061
James Sergent Work Experience Details
  • Bank Of America
    Architect 2 And Senior Oracle Application Dba
    Bank Of America
    North East, Md, Us
  • Bank Of America
    Architect 2 / Senior Oracle Application Dba
    Bank Of America Nov 2013 - Present
    Maryland
    Coordinate with application teams with design and analysis for new and existing Oracle Objects ; This includes tables, views, materialized views, PL/SQL Packages, procedures, and functionsResponsible for the deployments into all environments (Dev to PROD) by working with both application team and support DBA teamReview all SQL executed in the Oracle Databases for performance issuesReview ADDM/ASH/AWR Reports on a daily basisAssist with data modeling and physical modeling of current and upcoming projectsWork with support DBA’s to resolve any database issues
  • Rose International
    Senior Oracle Application Dba
    Rose International Apr 2012 - Nov 2013
    Newark, De
    Coordinated with application teams with design and analysis for new and existing Oracle Objects ; This includes tables, views, materialized views, PL/SQL Packages, procedures, and functionsWas responsible for the deployments into all environments (Dev to PROD) by working with both application team and support DBA teamReviewed all SQL executed in the Oracle Databases for performance issuesReviewed ADDM/ASH/AWR Reports on a daily basisAssisted with data modeling and physical modeling of current and upcoming projectsWorked with support DBA’s to resolve any database issues
  • Digital Infuzion
    Senior Oracle Application Dba
    Digital Infuzion Aug 2010 - Apr 2012
    Bethesda, Md
    Was responsible for all Oracle PL/SQL Development and maintenance which included packages, procedures, and functionsWorked with support DBA teams on all issuesMentored junior level PL/SQL DevelopersMentored junior level Application DBA’sResponsible for all Oracle Application development and maintenance which included which included tables, triggers, views, views, and materialized views Was part of team that received CCMI certification
  • Ics-Nett
    Senior Oracle Pl/Sql Developer
    Ics-Nett Nov 2009 - Jul 2010
    Suitland, Md
    Assisted in the development of ETL processes as part of the 2010 CensusCreated and maintained PL/SQL objects (packages, procedures, and functions)Worked with the business teams and app teams to resolve data issues
  • Teksystems
    Senior Oracle Application Dba
    Teksystems Sep 2006 - Nov 2009
    Newark, De
    Developed and maintained data marts residing on several Oracle 10g databases, including tables, views, and materialized viewsHeavy PL/SQL development included projects that were involved with creating ETL-related processes (either from flat files, or through Informatica), extracting data into flat files for transfer to other systems downstream, table partition maintenance (switching partitions, dropping old partitions, and adding new partitions), and code fixes to existing PL/SQL codeOracle Database administrative duties included maintaining users, tables, indexes, and tablespaces as well as performance tuning at both the SQL and database levelsNon-Oracle responsibilities included developing Informatica Workflows, administrating UAT and Production Installs with Peregrine Service Center, maintaining scheduled jobs through the Tivoli Maestro Job Scheduler, and maintaining code change control through the Borland StarTeam Application
  • Ksg Group, Inc
    Senior Oracle Pl/Sql Developer
    Ksg Group, Inc Apr 2006 - Aug 2006
    Wilmington, De
    Was responsible for the maintaining and developing of ETL Processes for a Pharmaceutical Reporting system which resided in an Oracle 9i DatabaseDeveloped PL/SQL as well as reviewed code from junior developersAssisted business managers with data analysisCoordinated database object and PL/SQL deployments for all environments, from lower levels to productionAssisted in the testing and development of a new replacement system
  • Bank Of America
    Oracle Database Dba / Developer
    Bank Of America Jan 1998 - Mar 2006
    Baltimore, Md
    Served simultaneous roles as an Oracle Database Administrator, Oracle Application Server Administrator, and an Oracle PL/SQL DeveloperDatabase Administrator responsibilities included maintaining multiple Oracle 8i and 9i environments as well as activities included user maintenance, back-ups, performance tuning, optimizing tablespace sizes, and software upgradesOracle Application Server Administrative duties include maintaining an Oracle 9iAS environment where the main components administered were Oracle Discoverer, Oracle Forms, and Oracle ReportsPL/SQL Developer responsibilities included creating and maintaining ETL processes, extraction processes, and activities related to manipulating data for use by the Oracle Application Server
  • Nationsbank Na
    Microsoft Access Developer
    Nationsbank Na Jan 1998 - Jul 1998
    Baltimore, Md
    Created and maintained a Cost Center Hierarchy database in Microsoft Access 97 that encompassed all the cost centers within the companyRedesigned Marketing Report Application so that it became a franchise-wide applicationMigrated an existing FoxPro Marketing Report Application into Microsoft Access 97
  • Synergy Incorporated
    Computer Programmer
    Synergy Incorporated Sep 1996 - Dec 1997
    Washington, Dc
    Developed ETL Processes using Pro*C to load data into an Oracle DatabaseDeveloped and maintained Crystal Report ApplicationsAssisted in the development of a Visual Basic / Oracle Application that processed government contract requests

James Sergent Skills

Sql Oracle Application Server Agile Methodologies Sdlc Pl/sql Iis Databases Requirements Analysis Data Warehousing Business Intelligence Oracle Etl Soa Sharepoint Oracle Applications Xml Integration Software Development Microsoft Sql Server Enterprise Architecture Web Services

James Sergent Education Details

Frequently Asked Questions about James Sergent

What company does James Sergent work for?

James Sergent works for Bank Of America

What is James Sergent's role at the current company?

James Sergent's current role is Architect 2 and Senior Oracle Application DBA.

What is James Sergent's email address?

James Sergent's email address is js****@****eit.com

What is James Sergent's direct phone number?

James Sergent's direct phone number is (866) 607*****

What schools did James Sergent attend?

James Sergent attended University Of Maryland Baltimore County.

What are some of James Sergent's interests?

James Sergent has interest in Football, Casinos, Exercise, Sweepstakes, Home Improvement, Reading, Sports, Watching Basketball, Home Decoration, Watching Sports.

What skills is James Sergent known for?

James Sergent has skills like Sql, Oracle Application Server, Agile Methodologies, Sdlc, Pl/sql, Iis, Databases, Requirements Analysis, Data Warehousing, Business Intelligence, Oracle, Etl.

Who are James Sergent's colleagues?

James Sergent's colleagues are Shqiponje Gashi, Mike Mandel, Judith Ramirez, Nick Giannakopoulos, Sangita Kumari, Anjali Mule, Alexandre Pancrazi.

Not the James Sergent you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.