SEARCH

Systems Engineer Resume Example

Resume Score: 80%

Love this resume?Build Your Own Now
SYSTEMS ENGINEER
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
Systems Engineer05/2016 to CurrentCompany NameCity, State
  • 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.
Database Engineer III05/2015 to 05/2016Company NameCity, State
  • 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.
Senior Software Engineering Manager07/2010 to 05/2015Company NameCity, State
  • 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
MCA: Master of Computer Applications 10/2008Andhra University, Visakhapatnam
Certifications
Teradata 12 Certification (TE0-121)
Microsoft Certified: Azure Fundamentals
Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

School Attended

  • Andhra University, Visakhapatnam

Job Titles Held:

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

Degrees

  • MCA : Master of Computer Applications 10/2008

Similar Resumes

View All
Systems-Engineer-resume-sample

Systems Engineer

Everett, Washington