LiveCareer-Resume
JC
Jessica Claire
Montgomery Street, San Francisco, CA 94105 (555) 432-1000, resumesample@example.com
Summary

11+ Years’ experience of which 9+ in providing the Database administration, Development, Automation Testing and Operations of Datawarehouse platform systems and applications by using Teradata, Greenplum and Azure Data Warehouse.
2 Years’ experience in MS-SQL server along with Microsoft Business intelligence (SSIS&SSRS) Development.

Skills
  • Python
  • Perl
  • Client service and support
  • Infrastructure development
  • Product development and improvement
Experience
05/2016 to Current Systems Engineer Illumio | Chicago, IL,
  • Designed operational support system to monitor, control, analyze and manage computer network.
  • Applied system updates to reduce impact to efficiency and equipment.
  • Utilized Python to handle debugging and automation scripting tasks.
  • Designed and delivered mission-critical infrastructure to maintain consistent availability and performance.
  • Coordinated and enhanced existing databases and established new databases as part of initiative.
  • Identified and resolved bottlenecks and hardware issues through troubleshooting techniques.
  • Provided status updates to keep upper management informed and to reach goals.
  • Collected, analyzed and reported product technical performance measures and key performance parameters.
  • Maintained and resolved issues with complex infrastructure through monitoring and troubleshooting.
  • Performed data analysis and code inspection of pre-release software, advocating for efficiency improvements and user-centric design principals.
05/2015 to 05/2016 Database Engineer III Arch Capital Group Ltd. | Winston Salem, NC,
  • Teradata Administration, Development, Management and Operations
    Monitor database performance and tune database management system as necessary.
    Support multiple Teradata systems including independent marts, disaster recovery, and the enterprise warehouse production environments.
    Manage/Monitor system performance, including workload management and throttling in TASM, query performance and tuning, physical node behavior, and amp work distribution.
    Consult on physical database implementations, PPI, skew analysis, join methods and types, and data access paths.
    Build ETL frameworks and tools to process, store and publish the data within the SLA
    Lead projects in regarding teradata database infrastructure changes and upgrades.
    Active Monitoring of the system using the Viewpoint
    Workload management using Filters, Throttles and workload designer viewpoint portlets.
    Enforce the database policies and procedures.
    Workload Analysis and Tuning using the Database Query logs (PDCR DBQL tables and Resusage tables)
    Troubleshoots alerts (skewed queries, Long Running jobs, Slow Nodes and disks, Database space and Table space etc.) and performance issues.
    Extensive experience working with Teradata incidents through Teradata @ Your Service and the Global Support Center (GSC).
    Partnering with application development teams to optimize SQL code by choosing right indexes, partitions and data types.
    Review and provide recommendations for the application code and Database objects before deploying in the Production database system.
    Offer assistance developers and business users to tune the application or queries or procedures.
    User access management and Role Based Security controls in database
    Monitor Database backups and resolve any issues.
    24X7 on call support.
07/2010 to 05/2015 Senior Software Engineering Manager Microsoft Corporation | Phoenix, AZ,
  • Understanding the specification and analyzed data according to client’s requirement.
    Identified business user requirements and prepared ETL strategies for data extraction, transformation and Loading into the data warehouse.
    Responsible for DBS up gradations/configuration and trouble shooting
    Responsible for creating DBS objects, user hierarchy and permissions (roles/Profiles) as per the requirement.
    Implement the workload management (TDWM rulesets) by using (TASM & Viewpoint).
    Responsible for trouble shoot the DBS server problem I all the components level (OS, PDE, FileSys, DBS, TDWM and Viewpoint) escalate the issues to support team if needed.
    Responsible for tracking the DBS controls and parameters changes in all levels (DBS/PDE/OS).
    E-E Monitor the DBS server through viewpoint.
    Good experience in data consistency check Ferret/CNS utilities (Checktable & Scandisk)
    Trouble shoots the hardware failure and escalates the issues to support team if needed.
    Responsible to upgrade the TD servers with latest software’s (DBS/PDE/Kernel/OS/TTU/Storage/Firmware/CIMIC/Viewpoint) from latest cert list.
    Including/using all the latest/new TD features (CP, JSON, IPE, Re-Drive, Re-config, In- memory etc...) in development.
    Extensively worked in data Extraction, Transformation and loading from source to target system using SSIS, Bteq, FastLoad and MultiLoad.
    Did error handling and performance tuning in Teradata queries and utilities.
    Did data reconciliation in various source systems and in Teradata.
    Involved in unit testing and preparing test cases.
    Involved in the design of physical models and logical models for the database.
Education and Training
Expected in 10/2008 MCA | Master of Computer Applications Andhra University, Visakhapatnam, , GPA:
Certifications
Teradata 12 Certification (TE0-121)
Microsoft Certified: Azure Fundamentals

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • Andhra University, Visakhapatnam

Job Titles Held:

  • Systems Engineer
  • Database Engineer III
  • Senior Software Engineering Manager

Degrees

  • MCA

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: