staff software engineer resume example with 10+ years of experience
JessicaClaire
Montgomery Street, San Francisco, CA94105609 Johnson Ave., 49204, Tulsa, OK
Home: (555) 432-1000
Cell:
resumesample@example.com
:
Professional Summary
Motivated and team oriented software Engineer with 10+ years of experience software development.
Skills
Languages: Java, Python, MSSQL, Perl, XML
Databases: SQL server, Couchbase, Cassandra
Tools: SSIS, SSRS, Intellij
Frameworks: Spring, Hibernate,
CI/CD: Jenkins, SVN, Stash, Bamboo, Git
Work History
Staff Software Engineer, 04/2015 to Current Lockheed Martin Corporation – Longmont, CO,
Exhibited strong technical aptitude and application expertise resulting in optimized performance, continuous improvement recommendations and product innovation.
Developed Spring boot backend service for ingesting events from a Kafka topic and storing in SQL Server for further processing and reporting needs.
Created an Java service/API to be invoked by an external vendor, to store the roaming location of IOT devices.
Designed and developed data ingestion pipeline for network usage data for ~30 million devices using SSIS, SQL Server(MSSQL) and Stored procedures.
Designed & developed an entire reporting framework for generating multiple mission critical reports which helped in finding issues early on before Customer enablement, this mitigated production bugs
Handled DEVOPS tasks for a project by configuring make scripts for deploying Dockerized applications into private cloud.
Started working with Kubernetes and EC2 containers as part of move from a private cloud to AWS.
Maintained a legacy JAVA service, responsible for syncing SQL Server with Couchbase.
Architected an entire ETL solution replacing traditional MS Replication, to handle increasing load. (has been running without any Bugs/defects for more than 3 years in a production environment which requires to be up 24*7).
Maintained internal Enterprise application called Datagrid (SQL+ Couchbase + Elasticsearch) by performing bug fixes and operational activities.
Implemented partitioning to resolve throttling issue on a single OLTP table which handled almost 90% of the transaction and mitigated contention issues and thereby doubling the insertion speeds.
Accountable for various projects like developing features/enhancements for production environment, maintaining benchmarking lab, designing solutions to mitigate database related problem, firefighting production bugs, optimizing code.
Initiated the process of identifying the lack of reporting framework for our massive IOT data resulting from various data sources, did a comprehensive market research and identified 2 vendors with whom we are dealing with to finalize a reporting framework.
Supported complex replication topology which included building back replication and data sync processes in case of fail overs.
Optimized a Stored procedure API call resulting in it taking less than 2 hours which earlier was taking 11 hours to complete the processing.
Designed database partitioning model for moving hot OLTP tables to a different database to ease up the load on the Log reader agent.
Building different environments to simulate production environment and making sure all the time that the deadlines and commitments are met and solutions delivered as promised.
Developing complex scripts, procedures and perform tuning/optimization to support the current schema on a day to day basis.
Collaborating with cross functional teams on day to day basis on different issues and driving them to completion and successfully communicating at every stage the status and progress of the state of the problem in an Agile environment.
Automated various day to day activities which eased up the effort taken by each member to do these tasks on a daily basis, which in turn resulted in more productive hours for the team.
Participate in code review sessions and lead design meetings and requirement gathering meetings with product
Provide support after hours to resolve critical production issues, and constantly automating day to day tasks as much as possible
Database Engineer, 04/2014 to 04/2015 Rtx – Cortaro, AZ,
Provide Support to existing services by developing complex TSQL Scripts and rewriting the Old legacy Code in a better way.
Created different Reports Using SSRS which would be used by the OPS team for getting alerts, monitoring systems and capacity planning purposes.
Perfomed POCs on reporting framework like (Qlik), to make sure how this can be introduced into the current environment and can be used to replace SSRS(Static reporting Framework).
Developed reports Like Chi square test and Index/Merge Throughput reports which were used for internal purposes to determine the effect of code and hardware on the current system.
Initiated the process of source/version controlling the Databases which helps in keeping track of changes and working towards implementation of CI process.
Database Engineer, 12/2012 to 04/2014 Rtx – El Segundo, CA,
Maintained dictionary application which was consumed by the clients to know statistics pertaining to their websites and its users.
Single point of contact for Synaptica(third party tool,to create and maintain new Dictionaries (user agent like OS/Browser and Device) which was introduced in the organization, hence proving the willingness to take responsibility and being accountable for it and delivering solutions as promised in a timely manner.
Developing Perl scripts for automating the loads and updates and integrating and automating them using SSIS Packages(Calling the batch files).
Writing Complex TSQL Scripts (Stored procedures, views,UDF’s and triggers etc) to complete the stories assigned in JIRA as a part of the Monthly sprint tasks.
Identifying slow running queries using profilers or directly from the Client Service team and working on resolving these queries by studying the executions plans and performing various other checks depending on the way the query is written.
Coming up with SSIS packages to automate many different production related processes, which required manual effort earlier.
Actively involved in understanding business needs by collaborating with developers and was responsible for developing efficient queries and migration scripts.
Developed complex database objects like stored procedures, views, functions, triggers, SQL jobs and performed query tuning.
Also used advanced concepts like CTE’s, Pivot, Ranking functions and advanced XML functions like nodes, value, modify etc.
Database Engineer, 01/2011 to 12/2012 Rtx – Boston, MA,
Created and maintained data models using ERWIN, used different ERWIN functionalities to come up with scripts and data models to meet the Organizations standards
Performed SDLC for different projects, which required script maintenance and execution as and when required on different environments like Test, QA, OS and PROD
Actively involved in understanding business needs by collaborating with developers and was responsible for developing efficient queries and migration scripts
Developed complex database objects like stored procedures, views, functions, triggers, SQL jobs and performed query tuning. Also used advanced concepts like CTE’s, Pivot, Ranking functions and advanced XML functions like nodes, value, modify etc.
Came up with SSIS Package to refresh internal environments from production database backup with ROBOCOPY command
Created database users, logins and roles at the database and server level, with appropriate permissions and access control mechanisms
Monitored Database alerts, failures and blockings on production systems and worked closely with Production Support team to investigate and resolve some of the production issues
Documented these issues/bugs/resolutions on the company WIKI page so that the solutions can be used as a reference for similar production issues in the future thus saving a lot of time and effort
Education
Masters of Science: Computer Science, Expected in to University Of Southern California, Angeles(USC) - , California GPA:
Bachelor of Engineering: Computer Science, Expected in 12/2010 to Mumbai University - , GPA:
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.