Systems Engineer Resume Example
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
|
|
Experience
Systems Engineer05/2016 to CurrentIllumioChicago , 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.
Database Engineer III05/2015 to 05/2016Arch 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.
Senior Software Engineering Manager07/2010 to 05/2015Microsoft CorporationPhoenix , 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
MCA: Master of Computer Applications 10/2008Andhra University, Visakhapatnam
Certifications
Teradata 12 Certification (TE0-121)
Microsoft Certified: Azure Fundamentals
Microsoft Certified: Azure Fundamentals
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.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
Resume Strength
- Word choice
- Measurable results
- Strong summary
- Typos
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
