Montgomery Street, San Francisco, CA94105(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 CurrentSystems EngineerIllumio | 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/2016Database Engineer IIIArch 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/2015Senior Software Engineering ManagerMicrosoft 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/2008MCA | Master of Computer Applications Andhra University, Visakhapatnam, , GPA:
Certifications
Teradata 12 Certification (TE0-121)
Microsoft Certified: Azure Fundamentals
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.